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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Power5
Helper IV
Helper IV

How can I get the Actuals Field to replace the budget field for that same month?

For example, In this photo I have Jan and Feb actuals and then all the budget numbers for the rest of the months of the year. Say it is April currently, I would then want only the Actual April field column to show and remove the April Budget field so on and so on.

 

Power5_0-1680560750929.png

 

5 REPLIES 5
Power5
Helper IV
Helper IV

Hello, 

 

Thanks for the reply. However; the actual and budget columns are in seperate tables. They are connected on account number but I can't build this measure because of that.

@Power5 , you can; to get correct the total have a measure like

 

Sumx(values(Account[Account]), calculate(if(isblank([Actual]), [Actual], [Budget])) )

Power5_0-1681233769845.png

These are my two tables being connected on GL/DEPT when I tried to write your DAX measure it did not work.

 

Also, my Budget and Actual Amount fields are not measures they are actual fields inside my tables.

amitchandak
Super User
Super User

@Power5 , Based on what I go

if(isblank([Actual]), [Actual], [Budget])

 

How to get a single continuous line for Actual and Target without any break: https://youtu.be/41yhZz2pNTI

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

Top Kudoed Authors