Please can you help me on below issue. I have created a table like below in power bi.
By default current month selection is applied and calculated CY and PY measures like below
CY= CALCULATE( Sum(SalesNetAmountGBP]),Date'[CurrentDayOffset]<=0)
Thanks in advance
Solved! Go to Solution.
@amitchandak thank you for your reply. The above solution works only for complete year(2022) selection. But is breaking when we select month or quarter. The measure should be dynamic based on Date selection.