Forum Discussion

RemiAnthonise's avatar
RemiAnthonise
Helper V
8 years ago
Solved

DAX: IF 'inside' SWITCH

Hi guys,    I have this DAX:     Aantal dagen einde contract = SWITCH ( TRUE (); ISBLANK(TODAY()); 0; 'Vehicles'[Eind leasecontract] > TODAY(); DATEDIFF ( TODAY(); 'Vehicles'[Eind leasecontra...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi RemiAnthonise,

     

    If you want to replace the "01-01-1900" with blanks, you can try the following two methods.

    1. Change it in the data source. If there are some non-date values in the date column?

    2. Replace it in the Query Editor.

    Regarding to the DAX formula, 

    1. ISBLANK(TODAY()) is always false.

    Can you share a sample?

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi RemiAnthonise,

 

If you want to replace the "01-01-1900" with blanks, you can try the following two methods.

1. Change it in the data source. If there are some non-date values in the date column?

2. Replace it in the Query Editor.

Regarding to the DAX formula, 

1. ISBLANK(TODAY()) is always false.

Can you share a sample?

 

Best Regards,

Dale

  • RemiAnthonise's avatar
    RemiAnthonise
    Helper V
    8 years ago

    hi v-jiascu-msft , I've replaced values in the query editor. I tried everything as a replacing value except 'null'. I thought this would give me 'null' as a text but it's a blank field.

    Problem solved!