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 

eric98's avatar
eric98
Helper II
5 years ago

Today when I use your solution, it doesn't work

  • littlemojopuppy's avatar
    littlemojopuppy
    Community Champion
    5 years ago

    eric98 create another post describing what you're trying to accomplish.  Include lots of details and provide some sample data for people to work with.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Yes, it didnt work for me either.