Forum Discussion
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...
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/1051123How to handle the condition
Hi Anonymous ，
Create a slicer table as below:
Table 2 = VALUES('Table'[Date])Then create 2 measures as below:
Measure =
var _myslicer=CALCULATETABLE(VALUES('Table 2'[Date]),FILTER('Table 2','Table 2'[Date] in FILTERS('Table 2'[Date])))
var _mindate=MINX(_myslicer,'Table 2'[Date])
var _maxdate=MAXX(_myslicer,'Table 2'[Date])
Return
CALCULATE(MAX('Table'[Value]),FILTER('Table','Table'[Date]>=_mindate&&'Table'[Date]<=_maxdate))Measure 2 =
var _myslicer=CALCULATETABLE(VALUES('Table 2'[Date]),FILTER('Table 2','Table 2'[Date] in FILTERS('Table 2'[Date])))
var _mindate=MINX(_myslicer,'Table 2'[Date])
var _maxdate=MAXX(_myslicer,'Table 2'[Date])
Return
CALCULATE(MAX('Table'[Value]),FILTER('Table','Table'[Date]>=_mindate-14&&'Table'[Date]<=_maxdate-14))
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Kelly
Did I answer your question? Mark my post as a solution!