Forum Discussion
Cumaltive Diff with missing days
- 1 year ago
Hello DonalMc
try thid DAX code
Usage =
VAR currentDate = 'ESB Data'[Date]
VAR currentType = 'ESB Data'[Type]
VAR previousDate =
CALCULATE(
MAX('ESB Data'[Date]),
FILTER(
ALL('ESB Data'),
'ESB Data'[Date] < currentDate &&
'ESB Data'[Type] = currentType
)
)
VAR previousReading =
CALCULATE(
SUM('ESB Data'[Reading]),
FILTER(
ALL('ESB Data'),
'ESB Data'[Date] = previousDate &&
'ESB Data'[Type] = currentType
)
)
RETURN
IF(
NOT ISBLANK(previousReading),
'ESB Data'[Reading] - previousReading,
BLANK()
)
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Thank you pankajnamekar25 - that works perfectly!