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 getting the previous dates value and working out the percentage diff between that and the current value. As the dates are not continious (working days only) it doesn't fully give me what im after.

 

Using the Dateadd function I have been able to return everything that is minus 1 day, but i would like it to return the value for the previous date regardless if it is continious date value. 

 

Prv Day Unused Limit = CALCULATE([Total Unused Limit],DATEADD(CARDS_DATES_POWERBI[date],-1,DAY))

 

 

 

 Any thoughts?

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 

6 Replies

    • 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.

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

    Hi imcdonald83,

     

    In your scenario, please first create a calculated column:

    predate =
CALCULATE (
    MAX ([Date] ), FILTER ( CARDS_DATES_POWERBI, CARDS_DATES_POWERBI[Date] < EARLIER ( CARDS_DATES_POWERBI[Date] ) ) )

    Then, create a measure:

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

    Best 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