Forum Discussion

Stharwani's avatar
Stharwani
Icon for Advocate II rankAdvocate II
8 years ago

Dax: convert monthly data to weeks

Hi team,

 

I am using this formula to show week number Weeks = ROUNDDOWN(('Date'[Date] - 'Date'[StartOfFY]+2)/7,0)+1 

 

When I try to show it along with months on a bar chart, the shared week appears twice. Is there any way to change this so it only appears once?

 

 

Thanks,

Sonali

Need Help
Show and Tell
Tips and Tricks

4 Replies

  • DAX0110's avatar
    DAX0110
    Icon for Resolver V rankResolver V
    8 years ago

    Hi Stharwani, the approach I'd suggest is to create another calculated column that computes the MAX(Month) for each Weeks value, then put that MAX(Month) column on the chart together with Weeks.

     

    On the other hand, if you want to "snap" each Weeks value to the lower of the two months, use MIN(Month)