Forum Discussion
Daily Values from Running Total
Hello, I am attempting to get daily values from the running total. I have three columns Key, Date, Cumulative Cases. I am trying to get the daily values per key. I have attached a picture from ...
Hi blackgold
Can you post sample data as text not image to be able to copy/paste that?
Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/
Key Date Cumulative Cases Baldwin, Alabama 4/10/2022 64 Baldwin, Alabama 4/11/2022 70 Baldwin, Alabama 4/12/2022 75 Baldwin, Alabama 4/13/2022 82 Autaga, Alabama 4/10/2022 18 Autaga, Alabama 4/11/2022 19 Autaga, Alabama 4/12/2022 19 Autaga, Alabama 4/13/2022 20 Tyler, Texas 4/10/2022 87 Tyler, Texas 4/11/2022 89 Tyler, Texas 4/12/2022 95 Tyler, Texas 4/13/2022 102 Hello VahidDM,
I have updated the question.
I come up with solution but it is only working on the sample dataset. When I use the same DAX formula on the actual dataset, PowerBI is stuck on working on it.
What will suggest on optimizing the DAX formula?
Thank you!
