thiscodeWorks - Organizing the best of code online

List view

#ms.pbi #dax #current.week #previous.week #dax.var #dax.return #dax.if #dax.blank #dax.divide #week.on.week.%-wow%

Sales-WoW% = 

VAR WoW =
    [Sales-WoW]
    
VAR PW = 
    [Sales-PW]
    
RETURN
    IF (
        PW = BLANK (),
            BLANK (),
        DIVIDE ( WoW, PW )
        )

#ms.pbi #dax #current.week #previous.week #dax.var #dax.return #dax.if #dax.blank #week.on.week-wow

DAX | Week-on-Week (WoW) Calc

Sales-WoW = 

VAR WoW =
    IF ( [Sales-PW] = BLANK(),
        BLANK(),
    [Sales-CW] - [Sales-PW] )

RETURN
    WoW

#ms.pbi #dax #previous.day #dax.calculate #dax.var #dax.return #dax.if #day.on.day-dod #day.on.day.%-dod% #dax.blank

DAX | Day-on-Day % (DoD%) Calc

Sales-DoD% = 

VAR DoD =
    [Sales-DoD]
    
VAR PD = 
    [Sales-PD]
    
RETURN
    IF (
        PD = BLANK (),
            BLANK (),
        DIVIDE ( DoD, PD )
        )

#ms.pbi #dax #previous.day #dax.calculate #dax.var #dax.return #dax.if #day.on.day-dod #dax.blank

DAX | Day-on-Day (DoD) Calc

Sales-DoD = 

VAR DoD =
    IF ( [Sales-PD] = BLANK(),
        BLANK(),
    [Total Sales] - [Sales-PD] )

RETURN
    DoD

DAX | Week-on-Week % (WoW%) Calc

DAX | Week-on-Week (WoW) Calc

DAX | Day-on-Day % (DoD%) Calc

DAX | Day-on-Day (DoD) Calc

Save snippets that work with our extensions