Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

IF and SWITCH in measures

I don't have much experience using IF for creating a measure and just stumbled across switch today, but it appears that if I want to create a measure using either, I can only use measures that I've a...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Anonymous,

     

    Please try a measure like this:

    Measure =
IF (
    MIN ( 'Table1'[Move Date] ) > TODAY ()
        || ISBLANK ( MIN ( 'Table1'[Move Date] ) ),
    MIN ( Table1[Address] ),
    MIN ( Table1[New Address] )
)

    IF_and_SWITCH_in_measures

     

    Best Regards,

    Dale

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

If you reference a column in a measure, you must use the fully qualified name (Table[Column]) and you must use an aggregator like MAX, MIN, SUM, etc.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Okay got it, so filtering through individual rows based on dates won't be an option it seems. Thanks 

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Depends, you can use CALCULATE with FILTER clauses to filter down to individual rows. I'd really need to see some sample/example data and expected output to steer you in the right direction.