Forum Discussion

domtrump's avatar
domtrump
Helper II
3 years ago
Solved

Sorting dates in pivot table

Sure this has been asked, but the "suggestions" I'm finding I either don't understand or do not apply to my particular situation. My data assigns all transactions that occur in a month to the last da...
  • Wilson_'s avatar
    Wilson_
    3 years ago

    Hello,

     

    You can add another column to your date table in the format YYYYMM to sort your MMM YYYY table on (the below should work). That would solve the error message you're getting and allow you to sort.

    FORMAT ( 'Dates'[Date], "YYYYMM" )

    ----------------------------------
    If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

Wilson_'s avatar
Wilson_
Memorable Member
3 years ago

Hello,

 

You can add another column to your date table in the format YYYYMM to sort your MMM YYYY table on (the below should work). That would solve the error message you're getting and allow you to sort.

FORMAT ( 'Dates'[Date], "YYYYMM" )

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)