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 All,
something simple I think but can't get it to work.
I have a graph where I am showing last years won deals :
Solved! Go to Solution.
Hi @Jitmondo ,
You could try use edate() function. Please check this measure.
measure =
var _date =selectedvalue('date'[date])
return
calculate(sum([value]),filter(allselected('table'),'table'[date]>=date(year(_date)-2,1,1)&&'table'[date]<=edate(_date,-24)))
Best Regards,
Jay
Hi @Jitmondo ,
You could try use edate() function. Please check this measure.
measure =
var _date =selectedvalue('date'[date])
return
calculate(sum([value]),filter(allselected('table'),'table'[date]>=date(year(_date)-2,1,1)&&'table'[date]<=edate(_date,-24)))
Best Regards,
Jay
thanks for replying, my last year (sameperiodlast year) works fine. I am trying to see if there is a way to alter this measure or a new measure to show the year before last...
Please check PARALELLPERIOD function then, it should work 🙂
PARALLELPERIOD function (DAX) - DAX | Microsoft Docs
Your interval should be -2 for example:
CALCULATE(SUM(InternetSales_USD[SalesAmount_USD]), PARALLELPERIOD(DateTime[DateKey],-2,year))
Good morning @Jitmondo
Please check this previus answer and see if they work for you:
Solved: TOTALYTD with SAMEPERIODLASTYEAR not working as ex... - Microsoft Power BI Community
If you have a slicer with the dates they should work.
Regards!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |