Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need help with date format

Hi, I used the following measure for month format "Month_Format = FORMAT('Calendar'[Date], "MMM'YY")". I wanted to show the data of Jan'20 after Feb'19, but I'm not able to do it.  Any help on this...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    Based on your description, I created data to reproduce your scenario.

    Table:

     

    Calendar(a calculated table):

     

    Calendar = CALENDARAUTO()

     

     

    There is a many-to-one relationship between two table.

     

    Finally, you may drag 'Year' and 'Month' columns from Calendar table to the visual. Here is the result.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

Based on your description, I created data to reproduce your scenario.

Table:

 

Calendar(a calculated table):

 

Calendar = CALENDARAUTO()

 

 

There is a many-to-one relationship between two table.

 

Finally, you may drag 'Year' and 'Month' columns from Calendar table to the visual. Here is the result.

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.