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