Forum Discussion
Anonymous
2 years agoNot applicable
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 ...
Anonymous
2 years agoNot applicable
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