Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Variance Today vs Yesterday

I have two visuals that I want to merger and show the delta between today's production vs yesterday's production?   However, I'm struggling to write the DAX formula to show the delta by day in one ...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

    You may remove .[Date] of the formula.For example:

    Yesterday = CALCULATE(SUM(Data[Production]),PREVIOUSDAY(Data[Dates]))

    Regards,

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yeah - it doesn't look user-friendly in the current format.

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous 

You may remove .[Date] of the formula.For example:

Yesterday = CALCULATE(SUM(Data[Production]),PREVIOUSDAY(Data[Dates]))

Regards,