Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Days since first case DAX

I would like to create some of the COVID-19 visualisations in Power Bi. So confirmed cases over time, but without using the date as the axis. I would like to use days since first case for each country.

 

Struggling to get the DAX for days since first case for each country

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    You could probably do something like this 

     

     

    Days since first case = int ( today() - firstdate(field with dates of cases))

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous  - I tried this and it is not giving the desired result. Thank you

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Anonymous wrote:

    So confirmed cases over time, but without using the date as the axis. I would like to use days since first case for each country.

     

    Struggling to get the DAX for days since first case for each country

    Could you share the sample data to let us know your scenario better?

     

    You could see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi V-lianl-msft  - So the table I am working with looks like this, and I am trying to recreate something almost similiar to the OurWorldInData visual shown here. I would like to know how I can calculate the days since 100th case. So for every day in the data set, we should know how many days since the first case for each country.