Forum Discussion
Solved
Yesterday vs 2 days ago
Hello experts! I have a problem with a Dax. I need to calculate percentage variance from Yesterday and 2 days agoYesterday and 2 days ago. In particular I have a table with inside a column "c...
Hello filippoalicicco,
Try this;
Measure 1 =
Yesterday = CALCULATE(SUM(ELENCO[Dat Creaz (trunc)]);
FILTER(Tabel1;
TODAY()-1=RELATED('CALENDAR'[Date])
))Measure 2 =
2DaysAgo = CALCULATE(SUM(ELENCO[Dat Creaz (trunc]);
FILTER(Tabel1;
TODAY()-2=RELATED('CALENDAR'[Date])
))Measure 3 =
Result = DIVIDE([Yesterday];
[2DaysAgo])-1Greets,
Ronald
Ronald123
Resolver III
Resolver IIIHello filippoalicicco,
Try this;
Measure 1 =
Yesterday = CALCULATE(SUM(ELENCO[Dat Creaz (trunc)]);
FILTER(Tabel1;
TODAY()-1=RELATED('CALENDAR'[Date])
))
Measure 2 =
2DaysAgo = CALCULATE(SUM(ELENCO[Dat Creaz (trunc]);
FILTER(Tabel1;
TODAY()-2=RELATED('CALENDAR'[Date])
))
Measure 3 =
Result = DIVIDE([Yesterday];
[2DaysAgo])-1
Greets,
Ronald
