Days since first case DAX

[Anonymous]

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

[V-lianl-msft]

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]

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. 

[Anonymous]

You could probably do something like this 

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

[Anonymous]

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