Forum Discussion
Issue in displaying date format
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
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.Hi,
Please help me with this issue as you have given a solution and it worked halfway through my process.
to go in detail. here's belowl am using a default two year slicer along with the period slicer.
default two year is where I am displaying data for the last two years automatically if I reset in power bi service.
I have synced the normal date slicer and this two year default slicer.when I try to change the "To Date" it is by default showing the minimum date as below.
As in above usual date I have is 202405 in the "To Date", I have changed it to 202401.
after changing "From Date" defaulted to minimum date of my backend date from server.