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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Help with a measure.

Hi

 

I have a measure for Occupancy per course as follows

 

Occupancy Forecast (%) =
DIVIDE(
SUMX('CTS Forecast Course Volume', [Forecast Total Attendees]),
SUMX('CTS Forecast Course Volume', [Capacity per Course] * [Trainer Ratio] * [Volume])
)

 

 

This gives me an Occupancy percentage per course (because of the SUMX) and I can summarize by month as each course is linked to a date table

 

I want to create a ytd measure of the same

 

I am using a custom ytd measure as our year ends 31/03 so for example 

 

YTD Forecast Total Attendeed = CALCULATE([Total Forecast Attendees],DATESYTD('DateMASTER'[Date],"31/03"))

 

where Total Forecast Attendees = sum(Forecast Attendees)

 

 

 

Any ideas on the YTD calculation needed for the Occupancy Forecast % YTD?

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , Not clear.

Is this not working

YTD Occupancy Forecast (%)= CALCULATE([Occupancy Forecast (%)],DATESYTD('DateMASTER'[Date],"31/03"))

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , Not clear.

Is this not working

YTD Occupancy Forecast (%)= CALCULATE([Occupancy Forecast (%)],DATESYTD('DateMASTER'[Date],"31/03"))

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
Anonymous
Not applicable

Thanks Amit....for some odd reason i didnt consider it, was over complicating it in my brain

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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