cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors