Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
EdouardPBI
Frequent Visitor

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/2022

FY 2021 --> from 07/01/2020 to 06/03/2021

 

the second table is the sales tables (date, amount)

 

 

and i have a relation between this two table

 

In my report i have a fiscal year slicer

i want to calculate the YTD and the Last Year YTD in a matrix by month 

 

thanks a lot,

 

 

 

 

2 REPLIES 2
EdouardPBI
Frequent Visitor

EdouardPBI_0-1679930459935.png

thks for your answer but i test this method yesterday but this method limit to 12 months and in this FY (2022) i have 15 month !

 

maybe you have aanother idea 

 

thanks a lot

 

amitchandak
Super User
Super User

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.