Forum Discussion

udian's avatar
udian
Icon for Helper III rankHelper III
10 years ago
Solved

Dynamic filtering according to other filter selction

Hi All,   I am building a report that needs to compare two time periods - either current month Vs previous month or previous month Vs two months ago. I added to indication columns to my time dimes...
v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

udian

 

I agree with MattAllington, we can use some time intelligence functions like DATEADD as below.

LastMonth_Sales =

CALCULATE ( SUM ( Table1[Sales] ), DATEADD ( 'Calendar'[Date], -1, MONTH ) )

 

I’ve uploaded a .pbix file of simple sample here for reference. Hope it helps.

 

Best Regards,

Herbert

udian's avatar
udian
Icon for Helper III rankHelper III
10 years ago

Thanks for your help!