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

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago
Hi Anonymous,

Like in any measure the use of columns suppose to have an aggregator to make the comparision so using IF or SWITCH in your measure with a date column you must use a MAX, MIN for example to make the selection within your column and the IF / SWITCH function work properly.

Regards,Felix
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Yep, that's what smoupre said.

 

smoupre:  here's a sample of the data - the expected Current Locaiton for No. 1 would be (using TODAY() and assuming it's 2/3/2018), would be Acorn Street, for No. 2 it would be Bling Street, for No. 3 it would be High Street, and No. 4 it would be Mountain Street. Is the best option here to create a new column for the current location using the dates?

 

No.AddressNew AddressMove Date
1Acorn StreetCamp Street10/31/2018
2Doe StreetBling Street2/1/2018
3High Street1st Street8/1/2018
4Car StreetMountain Street1/1/2018
  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      It looks like that worked, thank you so much! I don't (or didn't until now) have any experience with the || (or &&) operators, those look like they will be very helpful going forward, I appreciate it.