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

I tried the formula but the "Production Sum Yesterday" measure didn't work. Can you have a look?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous - 

It will work if you expand the date. Unfortunately, it doesn't look very good. Another approach is to add a separate date table. There are many scripts available to create one in DAX or M (Power Query).

Cheers!

Nathan

  • 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
      Microsoft Employee
      7 years ago

      Hi Anonymous 

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

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

      Regards,