Forum Discussion
Solved
Prior Period Comparative Dynamic Date Range
Dear PowerBI Community, I have a very simple table which includes UNITS, and REVENUE but have applied a date range filter to the data. I would like to add a supplementary column to the table...
Lets try this way
Prior Year Revenue = CALCULATE(sum(Revenue[total_net_lc(exvat)]),DATEADD(Dates[Date],-1,YEAR))
Lets try this way
Prior Year Revenue = CALCULATE(sum(Revenue[total_net_lc(exvat)]),DATEADD(Dates[Date],-1,YEAR))
Thanks Rafael, I seemed to be going round in circles. Appreciate your help - TY!