how to merge budget and realization in one colums

[MauriceK]

Hi,

My dataset looks like:

I would like to "merge" realization and budget in 1 column so I can make a more beautiful visualization. 

When there is a value for realization then budget is always null. And for futher months realization is null and

a value is shown for budget. 

In this example today is 31-05-2022.

Thank in advance. 

[MauriceK]

HI Solutions work for me. 😄

[PC2790 · Accepted solution]

Hey @MauriceK ,

You can add a new column using DAX which would look like:

budget/realisation = if([budget] = 0, [realisation],[budget])

 See if it caters to your requirement.