Forum Discussion

logan_logan's avatar
logan_logan
Icon for Helper I rankHelper I
2 years ago
Solved

Weekly growth in trend

Hi, I saw some DAX for weekly growth from daily sales. However my problem is weekly growth is possible in cards, but when it is in trend(bar growph) along the week column (which is text, like "week-...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks for the reply from adudani and NordicDrow.

     

    Hi logan_logan ,

     

     1.Change date to week of year in Power Query Editor:

     

    2.Create simple measures:

    WeeklySales = CALCULATE(SUM([Sales]), ALLEXCEPT('Table', 'Table'[Week of Year],'Table'[Product]))
    WeeklyGrowth = 
VAR CurrentWeekSales =  CALCULATE(SUM([Sales]), ALLEXCEPT('Table', 'Table'[Week of Year],'Table'[Product]))
VAR PreviousWeekSales = CALCULATE('Table'[WeeklySales], 'Table'[Week of Year]= MAX('Table'[Week of Year]) - 1)
RETURN
IF(NOT ISBLANK(PreviousWeekSales), (CurrentWeekSales - PreviousWeekSales) / PreviousWeekSales, BLANK())

     

    3. Sort by week of year:

     

    4. The result is as follows:

     

    I can't reproduce your problem based on my tests, can you provide some more specific descriptions and screenshots as well as the dax formula you're using, it will help the problem to be solved more quickly.

     

    Best Regards,
    Zhu
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks for the reply from adudani and NordicDrow.

 

Hi logan_logan ,

 

 1.Change date to week of year in Power Query Editor:

 

2.Create simple measures:

WeeklySales = CALCULATE(SUM([Sales]), ALLEXCEPT('Table', 'Table'[Week of Year],'Table'[Product]))
WeeklyGrowth = 
VAR CurrentWeekSales =  CALCULATE(SUM([Sales]), ALLEXCEPT('Table', 'Table'[Week of Year],'Table'[Product]))
VAR PreviousWeekSales = CALCULATE('Table'[WeeklySales], 'Table'[Week of Year]= MAX('Table'[Week of Year]) - 1)
RETURN
IF(NOT ISBLANK(PreviousWeekSales), (CurrentWeekSales - PreviousWeekSales) / PreviousWeekSales, BLANK())

 

3. Sort by week of year:

 

4. The result is as follows:

 

I can't reproduce your problem based on my tests, can you provide some more specific descriptions and screenshots as well as the dax formula you're using, it will help the problem to be solved more quickly.

 

Best Regards,
Zhu
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.