Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

previous day with last day data missing

Hi All,

 

I hope you can assist me.

I have data with Exchange rates for every day and added a previous day column.

But when the last day data is missing(it's ok, it happened), This creates a problem for me in the KPI chart because there is a comparison between the previous day that has data to the one before it because the data will always be equal.

Is there a way around it?

 

Thank you,

 

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , Try a new column like

     

    var _last = maxx(filter(Table, [Currency] = earlier([Currency]) && [Date] < earlier([Date])), [Date])
    return
    maxx(filter(Table, [Currency] = earlier([Currency]) && [Date] =_last), [USD_ILS_DATE])

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi,

       

      thank you,

       

      but it writes me an error, you have idea how to pass this?

       

       

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi Anonymous ,

     

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

     

    Refer to:

    How to provide sample data in the Power BI Forum

    How to Get Your Question Answered Quickly

     

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.