Forum Discussion

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
7 years ago
Solved

Arrange Week number and Year

I don't know why this is behaving this way. How can I switch the 53rd of 2018 and 1st of 2019?   Here is my code. WeeknYear = 'Date Table'[WeekNumISO] & " " & 'Date Table'[Year]  
Need Help
Show and Tell
Tips and Tricks
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi mussaenda ,

    For your scenario, I need more information to understand it better.

    By my tests, I cannot reproduce your scenario.

    If it is conveninent, could you share the dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

    Best  Regards,

    Cherry

     

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi mussaenda ,

For your scenario, I need more information to understand it better.

By my tests, I cannot reproduce your scenario.

If it is conveninent, could you share the dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best  Regards,

Cherry

 

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
7 years ago

Hi v-piga-msft ,

 

Sorry I just read your msg. I just filtered it by year so the error will not occur. But I am still puzzled why it is happening. Maybe there is something wrong with some of my codes.

 

Thank you for the ff.