Forum Discussion

Malinpetersson's avatar
Malinpetersson
Regular Visitor
6 years ago

Yesterday or day before

Hi!   I need a mesure that brings the value back if ther is a value yesterday and if not it will bring the value from the day before yesterday, or before that day, last year. The value I am looking...
Need Help
az38's avatar
az38
Community Champion
6 years ago

Hi Malinpetersson 

it is not Power QUery question, as I understand. Better use DAX or Desktop forum sections

I do not clearly understand what your desired result but maybe you should try a measure like 

Measure = 
var _lastDayWithData = CALCULATE(MAX(Table[Date]); NOT(ISBLANK(Table[Summa Fakturerat])) )

RETURN

CALCULATE(SUM(Table[Summa Fakturerat]);  Table[Date]=_lastDayWithData )

for better response please provide data example and desired output