How do I get DAX to subtract row by previous row.
I am working on SQL Server direct query mode and unable to crack this for my report
Please advise and kindly refer to excel sample data and formula below I’ve tried
[TotalQty] = Divide(SUM([delivered_quantity]),SUM([req_quantity]),0)` PreviousRowSubtract = ([TotalQty]) - CALCULATE ( SUMX([delivered_quantity])/SUMX([req_quantity])*100,FILTER([Date]=dateadd([Date],-1,Day)))
Column D is what I am trying to achieve this would have other filter contexts like Year, MonthNum, WeekNum and Weekday in the form of Slicers
SampleData.xlsx (9.2 KB)