Forum Discussion

EdouardPBI's avatar
EdouardPBI
Frequent Visitor
3 years ago

Cumulative LastYear

Hello everyone,   i have two table dim date with (date,month, year, fiscal year)   the fiscal year equal to   FY 2023 --> from 10/01/2022 to 09/30/2023 FY 2022 --> from 07/01/2021 to 09/30/202...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

EdouardPBI , Try like

 

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"09/30"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"09/30"))

 

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s