thiscodeWorks - Organizing the best of code online

List view

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

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 | Day-on-Day % (DoD%) Calc

DAX | Day-on-Day (DoD) Calc

Save snippets that work with our extensions