Forum Discussion

Pat8's avatar
Pat8
Frequent Visitor
4 years ago
Solved

Change column value based on slicer

I have a table with months and showing amounts and a measure comparing last month and this month's amount: Month This Month Not This Month Amount Measure: Amount - Lastmonth amount 1-Jan ...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi Pat8 ,

     

    You need to create a disconnected table as a slicer,

    slicer = DISTINCT('Table'[Month])


    then create the following measure:

    Measure = IF(MAX('Table'[Month])>SELECTEDVALUE(slicer[Month]),TRUE(),FALSE())

     


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

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Pat8 ,

 

You need to create a disconnected table as a slicer,

slicer = DISTINCT('Table'[Month])


then create the following measure:

Measure = IF(MAX('Table'[Month])>SELECTEDVALUE(slicer[Month]),TRUE(),FALSE())

 


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