Measure - Switch between two columns based on slicer selection

[Aase]

Hi guys.

I am currently trying to create a Forecast report for our management.

Basically they would like to be able see either Budget- or Realised numbers, based a slicer selection.

Example: They want to be able to select "May, 2023" in a slicer and then see realised numbers from Startdate to May 31st and budget numbers from June 1st to Enddate.

I am really struggling in creating a meassue that can do this.

I am using DirectQuery mode, so I am not able to create calculated tables or coloums.

Any help?

Coloums:

Real: 'Finance'[Finance Amount]

Budget: 'Finance'[Finance Budget]

Calendar date: 'Calendar'[Calendar Date]

Calendar month: 'Calendar'[MonthName]

[v-zhangti · Accepted solution]

Hi, @Aase 

You can try the following methods.
Sample data:

Measure = IF(SELECTEDVALUE('Calendar'[Calendar date])<SELECTEDVALUE(Finance[Date]),SUM(Finance[Finance Budget]),SUM(Finance[Finance Amount]))

Calendar date and Date do not establish a relationship. Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Aase]

Anybody?