Forum Discussion

Matjo's avatar
Matjo
Icon for Advocate I rankAdvocate I
8 years ago
Solved

Slicing on a date when dates are represented by a range

I have the following information about customers:  Customer_id Customer_type Start_date End_date 1 A 2017-01-01 2017-06-30 1 B 2017-07-01 2017-12-31 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You may download my PBI file from here.

     

    Hope this helps.

     

Matjo's avatar
Matjo
Icon for Advocate I rankAdvocate I
8 years ago

v-frfei-msft Thank you very much for your help! It works great except that it does not handle the null values in the column but that is fixed easy. 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

You are welcome.  In the Query Editor, you should be able to filter out the NULL values.