Forum Discussion

Karolina411's avatar
Karolina411
Icon for Helper V rankHelper V
4 years ago

Date mismatches

Hello So...my date column in my date dimension is not working all of a sudden----I tried to ensure both are dates only but that is not working - when I use MONTHDATE (as below) it cannot get into da...
Date Issues DateTime
VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Hi Karolina411 

 

Add a calculated column based on your date to show the YYYYMM like 202101=Jan-21

 

then create another column to show the MMMM YY like January 2021, and sort it by the previous ↑ calculated column.

 

Then you can use it in your report.

 

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/