Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Custom Date Table - Same Month Returning as 2 Month Numbers

Hello everyone!   I created a custom Date Table for our Fiscal Year where February = Month 1 and built my custom columns from this. It seemed to be working fine, however, I tried to recreate custom...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Anonymous 

    Same issue happened to me with month(), you may used the following column instead.

     

    Column = IF(([Date].[MonthNo])=1,12,([Date].[MonthNo])-1)
     


    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Oh ok I wonder If the format of the date column changed. Have you tried adjusting it in column settings? that might of caused the issue if it worked previously. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Nothing has changed... in fact when I tried to recreate the month number column on the same table with the correct month numbers, I get the same issue. Thanks for replying!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hey Anonymous 

    this one is weird i opened up my laptop duplicated your query and then couldn't get the same issue.  i get the corrected result.   not sure what is happening in you report.  any chance you could send a copy to see what is happening?