Forum Discussion
Daily Values from Running Total
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!Why not using it as a Measure instead of a calculated column. The DAX will work just fine into a measure.
I tired that and I get an error saying:
A single value for column 'Key' in table 'Table' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
