Forum Discussion

Chirag_Sidana's avatar
Chirag_Sidana
Frequent Visitor
8 years ago
Solved

Changing Measure Values to Months/Days

Hi,   I have created a measure which calculates the number of days to achieve a certain target. However, since the # days are coming out to be 100+ for a lot of cases, I would also like to give the...
Need Help
  • alexei7's avatar
    alexei7
    8 years ago

    Hi Chirag,

     

    The DATEDIFF DAX function should help with what you're trying to achieve.

     

    You could create different measures using this function for Days, Weeks, Months difference etc and then have a slicer to allow the user to select one of these measures.

     

    Hope that helps

    Alex

alexei7's avatar
alexei7
Continued Contributor
8 years ago

Hi Chirag,

 

The DATEDIFF DAX function should help with what you're trying to achieve.

 

You could create different measures using this function for Days, Weeks, Months difference etc and then have a slicer to allow the user to select one of these measures.

 

Hope that helps

Alex

Chirag_Sidana's avatar
Chirag_Sidana
Frequent Visitor
8 years ago

Thanks for your response Alex! I wasn't sure how DATEDIFF could fix this but I did create two measures - one for date and month each and used slicer to change the view between these two measures. This does help me achieve the view I wanted.

 

Thanks Again!

Chirag

 

  • alexei7's avatar
    alexei7
    Continued Contributor
    8 years ago

    Great, glad I could help!