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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
JuniorPowerBI
Frequent Visitor

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

@JuniorPowerBI , 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

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.