Forum Discussion

elatreille's avatar
elatreille
Icon for Helper I rankHelper I
9 years ago
Solved

Today()-1 vs Today()-2

Hi all,   I need to display in a column graph data from 2 days and yesterday. So the chart will easilly show the 2 days trend. I used this in Power BI desktop and it works well but when gets time...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    elatreille,

     

    You could also create measures as shown below.

    Yesterday =
SUMX (
    FILTER ( AdvRev, AdvRev[Date] = MAX ( AdvRev[Date] ) - 1 ),
    AdvRev[Total impressions]
)

    Two_Days =
SUMX (
    FILTER ( AdvRev, AdvRev[Date] = MAX ( AdvRev[Date] ) - 2 ),
    AdvRev[Total impressions]
)
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago

Hi there, 

 

What about if you change your measure from TODAY() to use DATEADD

 

Here is an example: 

Yesterday = CALCULATE(SUM('AdvRev'[Total impressions]),DATEADD('Calendar'[Date],-1, DAY))
elatreille's avatar
elatreille
Icon for Helper I rankHelper I
9 years ago
Both ways works for yesterday but not working for 2 daus ago so if I replace -1 by -2 for 2 days before, it returns the same numbers from yesterday.