Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Issue in displaying date format

Hi,   I have a date format in a slicer like 202106 and 202405. I want to show these dates in an alphabetical way like "June 2021 to May 2024".  I have data from the backend that starts from 1990 ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Suppose we have:

Please create a new measure:

Measure = CALCULATE(MIN('Date'[Month Year]),'Date'[Year Month]=MIN('Date'[Year Month])) & "-" & CALCULATE(MIN('Date'[Month Year]),'Date'[Year Month]=MAX('Date'[Year Month]))

output:

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

Thank you for the help. The solution you have shared helped me through halfway.

If I try to choose the range of dates in "To Date" side, the "From Date" is going to minimum value as shown below.

This is happening only when I select the "To Date". 
can you help me to make it as per my selection.