Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter data in previous period

I have 2 donut charts. The one on the left shows data in the specified period the users chooses. This period is selected using a date filter in the filter pane that affects all visuals in the same p...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , you need to combine few calculations like for month, qtr , year like

 

Rolling 2 = CALCULATE(distinctcount(Transation[Month-Year]),DATESINPERIOD('Date'[Date],today(),-2,MONTH))

 

for week

https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123

 

How to handle the condition

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115