Forum Discussion
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:...
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.
Anybody?