Forum Discussion
Difference from previous working day
Dear community members, Looking for your expert advice on the following scenario: I have a table with day-wise performance. The days in the table contain only working days (so, no data for Sa...
Hope this helps
Difference = IF(ISBLANK(CALCULATE(SUM('Table'[Leads]),OFFSET(-1,ALLSELECTED('Table'[Date]), ORDERBY([Date],ASC),DEFAULT))),"",CALCULATE(SUM('Table'[Leads])-CALCULATE(SUM('Table'[Leads]),OFFSET(-1,ALLSELECTED('Table'[Date]), ORDERBY([Date],ASC),DEFAULT))))