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.

Helper III
Helper III

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 III
Helper III



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

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.

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