Forum Discussion

imcdonald83's avatar
imcdonald83
Regular Visitor
9 years ago
Solved

Previous date values

Hi Guys   Hoping you can maybe help. Im new to Power BI, and I have been working on some dashboard to help calculate the % shift of sales day on day.    I have got it working to an extent by gett...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi imcdonald83,

     

    Sorry for my mistake. Rather than a measure, we should create a calculated column using:

    Pre = CALCULATE([Sales],CARDS_DATES_POWERBI[Date]=EARLIER(CARDS_DATES_POWERBI[predate]))

     

    Regards,
    Yuliana Gu 

imcdonald83's avatar
imcdonald83
Regular Visitor
9 years ago

v-yulgu-msft

 

The creating of the predate column works fine, but the Earlier function is not recognising predate as part of a measure. 

 

EARLIER/EARLIEST refers to an earlier row context which doesn't exist.

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi imcdonald83,

 

Sorry for my mistake. Rather than a measure, we should create a calculated column using:

Pre = CALCULATE([Sales],CARDS_DATES_POWERBI[Date]=EARLIER(CARDS_DATES_POWERBI[predate]))

 

Regards,
Yuliana Gu