Forum Discussion

nick9one1's avatar
nick9one1
Icon for Helper III rankHelper III
3 years ago

Date format changing when converting to text

I have a date slicer that constantly updates with new dates, but I also always need the latest date selected.  the only way I have found to do this is to change the MAX date to text "Latest Week" ...
Need Help
mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago

Hi nick9one1 

 

Have you tried to change to text by doing this?:

 

fw as week text = FORMAT('Lettings Fact_Lettings_Summary'[FW as Date],"DD MM YYYY")

 

I think, you'll keep the expected format