Announcements
cancel
Showing results for
Did you mean:
Specialist

## Outer set expression combined with pick(match(

I want to compare the current month with the previous month.

The result is build up from a Pick Match, where the master items T1A etc are the KPI calculations with there own calculations with set analysis in it.

Current month:

{<_YearMonth_serial = {"\$(=Max(_YearMonth_serial))"}>} Pick(Match('\$(T1orT2)', 'T1','T2','T2_S1'), T1A, T2A, T2C)

Previous month:

{<_YearMonth_serial = {"\$(=Max(_YearMonth_serial)-1)"}>} Pick(Match('\$(T1orT2)', 'T1','T2','T2_S1'), T1A, T2A, T2C)

The result is het sum [Current month] - [Previous month] by combining both statement as 1 measure like this:

{<_YearMonth_serial = {"\$(=Max(_YearMonth_serial))"}>} Pick(Match('\$(T1orT2)', 'T1','T2','T2_S1'), T1A, T2A, T2C)

- (minus)

{<_YearMonth_serial = {"\$(=Max(_YearMonth_serial)-1)"}>} Pick(Match('\$(T1orT2)', 'T1','T2','T2_S1'), T1A, T2A, T2C)

This does not work because it are 2 different outer set operators. At least, I have not found a way to make it work.

Do yo have solution? Thanks

Labels (1)
• ### General Question

1 Solution

Accepted Solutions
MVP

I'm not entirely sure what the issue here is, but have you tried using:

RangeSum({<_YearMonth_serial = {"\$(=Max(_YearMonth_serial))"}>} Pick(Match('\$(T1orT2)', 'T1','T2','T2_S1'), T1A, T2A, T2C) , -{<_YearMonth_serial = {"\$(=Max(_YearMonth_serial)-1)"}>} Pick(Match('\$(T1orT2)', 'T1','T2','T2_S1'), T1A, T2A, T2C))