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.

vivran22's avatar
vivran22
Community Champion
4 years ago

Hello Pat8 ,

 

You may try this:

 

 

Selected Measure =
VAR _PrevMonth = PREVIOUSMONTH('Table'[Month])
VAR _Calc =
SELECTEDVALUE('Table'[Amount]) - CALCULATE(SUM('Table'[Amount]),PREVIOUSMONTH('Table'[Month]))
VAR _Check = IF(NOT ISBLANK(_PrevMonth),_Calc)
RETURN
_Check
 
Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂 (Hit the thumbs up button!)
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)


https://www.vivran.in/

Connect on LinkedIn
Pat8's avatar
Pat8
Frequent Visitor
4 years ago

Thanks for the reply! What I need is the TRUE/FALSE based on the selected month on the slicer.