Forum Discussion

Aase's avatar
Aase
New Member
3 years ago
Solved

Measure - Switch between two columns based on slicer selection

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's avatar
    v-zhangti
    3 years ago

    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.

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    3 years ago

    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.