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

You could do a switch or nested if statement 

 

so if month from date is February then 2 if month from date is March then 3 etc. 

 

last thing is make a calendar in excel based on what you want and then query it in. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks! My issue is it worked in the past, so not sure why it stopped working.

  • 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?