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 countr...
Need Help
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