Changing Measure Values to Months/Days

[Chirag_Sidana]

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 user an option to show the measure in # months if desired. So basically a click functionality where the user can chose to see the measure in months or days. This would have been simple in Tableau using parameters but I am not sure if Power BI parameters can be used the same way.

Thanks in advance,

Chirag

[alexei7 · Accepted solution]

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]

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]

Great, glad I could help!