Forum Discussion

hanmcm's avatar
hanmcm
Frequent Visitor
7 years ago

Creating a data Range for a column that was created using DAX

I have created a Notice Period in data view using this DAX formula " Notice Period = DATEDIFF([SUBMIT_DATE].[Date], [DEPARTURE_DATE].[Date], DAY) " I would like to group the totals into different ranges but all solutions are advising to use a calculated column in query editor which does not pull in the notice period. Is there a way to create the range in dax as a measure or the the notice period in query editor?

 

Thanks in advance any help welcome.

 

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    Hi hanmcm,

     

    What's the total and what's the different ranges? Could you share some details about your requirement?

     

    Regards,

    Jimmy Tao

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    Hi hanmcm,

     

    Have you solved your issue by now?

     

    Regards,

    Jimmy Tao