Skip to main content
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.

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.




Helper IV
Helper IV



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])) )


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.

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:

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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


Power BI Monthly Update - May 2024

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

Top Kudoed Authors