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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
Anonymous
Not applicable

Measures for Time Intelligence/ Calculation Groups

Hello there, 

I am trying to create measures for Time Intelligence - However all my measures show me same values despite having proper formulae. I have a raw data which has 2 columns - fiscal year and fiscal period. I have merged these 2 columns to create a FiscalYearPeriod to establish connection with a Date table (I am only able to establish many to many relationship). The Date table has a FiscalYearPeriod Column. Our Fiscal year starts from August so 1/08 is fiscally 1/01 for us. Please find attached the link to the data. I would appreciate any sort of help here. (PS: I did try creating a Fiscal Date column in Raw Data table to try to establish a many to one relationship but that doesn't change the o/p. Also I have consolidated 2021,2022 and 2023 data into a new table RawData in PowerBI)

 

https://drive.google.com/drive/folders/1TTqNslHf-I477czkR5JJf4E7ZMOqCi0b?usp=share_link 

vyaskhyatis1_0-1674182184226.png

 

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , For YTD you have try measures like

 

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

 

FY period and sort should do rest

 

:Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

Check out the May 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

May 2025 Monthly Update

Fabric Community Update - May 2025

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