topic Re: Set Analysis Formula with 2 Measures in App Development

Set Analysis Formula with 2 Measures

joshdellapietro — Mon, 20 Dec 2021 21:08:46 GMT

Hello,

I want my formula to filter on max Year (2020) and then filter on the max month for 2020, which is 4 (April). The first part is picking up 2020, but since I have 2019 loaded, the max month function is picking up 12 (December).

Here is what I am currently using:

Sum({$<[Year]={$(=(Max([Year])))},[Month #]={$(=Max([Month #]))}>}[PY Net Sales])

My data looks like this:

Year	Month #
2019	12
2020	1
2020	2
2020	3
2020	4

Re: Set Analysis Formula with 2 Measures

Anil_Babu_Samineni — Fri, 10 Apr 2020 12:38:28 GMT

Perhaps this?

Sum({<Year={"$(=Max(Year))"}, [Month #]={"$(=Max({<Year={"$(=Max(Year))"}>} [Month #]))"}>} [PY Net Sales])

Re: Set Analysis Formula with 2 Measures

joshdellapietro — Fri, 10 Apr 2020 13:19:06 GMT

This worked perfectly, thank you!