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

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?