Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Team,
I am new here , and would love to get your help on this!
I am working on a dashboard where using a line graph, the date range on that needs to filtered for 6 months (Previous 6th month to 'Till Date') eg: 01 June 2020 to 05 Novemeber 2020 (Current Date).
I tried to use the relative filter but both the month Options did not do what i need.
Can you kindly help me out on this one!
Thanks in advance!
Solved! Go to Solution.
@NandhaKumarPBI , Try a rolling measure like this with a date table
Rolling 6 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-6,MONTH))
Also, refer to this video: https://www.youtube.com/watch?v=duMSovyosXE
Hi @NandhaKumarPBI ,
Relative date slicer should work. Or you could create a measure as below and add it to visual filter.
Measure = IF(SELECTEDVALUE('Table'[date])>=EDATE(TODAY(),-6),1,0)
Best Regards,
Jay
Hi @NandhaKumarPBI ,
Relative date slicer should work. Or you could create a measure as below and add it to visual filter.
Measure = IF(SELECTEDVALUE('Table'[date])>=EDATE(TODAY(),-6),1,0)
Best Regards,
Jay
@NandhaKumarPBI , Try a rolling measure like this with a date table
Rolling 6 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-6,MONTH))
Also, refer to this video: https://www.youtube.com/watch?v=duMSovyosXE
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |