Forum Discussion

Lynzmaz's avatar
Lynzmaz
Regular Visitor
4 years ago

Weekly sales variance % format Measure

Hi there,   I have spent many many days trying to get a measure to work to compare this week vs last week net sales in % format per store. Not sure if my calendar is set up wrong or where is the pr...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi Lynzmaz ,

 

According to your description, a separate calendar table needs to be created. Then create another column to find the number of days of the week corresponding to the date. The measure created to find the difference between the two weeks corresponds to the following reference:

Num = WEEKNUM('calendar'[Date],2)
M_ = 
VAR a =
    WEEKNUM ( TODAY (), 2 )
RETURN
    CALCULATE ( SUM ( 'Table'[Value] ), a = 'calendar'[Num] )
        - CALCULATE ( SUM ( 'Table'[Value] ), a = 'calendar'[Num] - 1 )


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


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