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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
IamTDR
Responsive Resident
Responsive Resident

Report Show Both YTD Budget and Full Yr Budget

Afternoon

 

I'm fairly new to Power BI and Dax but was wondering if anyone knew how to show the Budget both as of YTD and Full Year while the report is using slicers?

 

My request is to show Actual vs Budget and Full Year Budget minus Actual to show Year to Go. 

 

I am am also using slicers for each month of the calendar year so that my end users may also do Month to Date. 

 

I have no problem with the Actual vs Budget YTD it’s just can I also have Full Yr Budget?  My Budget is by product level. 

 

Thanks in Advance

1 REPLY 1
v-sihou-msft
Employee
Employee

@IamTDR

 

To get the Full Year Budget based on the selection in slicer, you can write a measure like below: 

 

Measure = CALCULATE(SUM('Internet Sales'[Sales Amount]),ALLSELECTED('Date'[Calendar Year]))

Regards,

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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