Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
Please go through both the set and tell me the difference in output??
1-=sum({<Month={$(=month(max({<Year={$(=year(max(Date)))}>}Date)))},Year={$(=year(max(Date)))}>}[Sales Amount])
2-=sum({<Month={$(=month(max(Date)))},Year={$(=year(max(Date)))}>}[Sales Amount])
I don't think you will see any difference...
The output won't differ.
Nothing there, If you use first expression the performance is ok but file size is bit increased. This scenario, I would recommend to use second one
sum({<Month={'=$(=month(max(Date)))'},Year={'=$(=year(max(Date)))'}>}[Sales Amount])
Nope there will be mo change in the output but the equation 1 is more detailed but not required. Equation2 is more than enough.
No change in the output.