Forum Discussion
daily change
so i have the following data
| Country/Region | casos | Mes | Día | casos por dia |
| Argentina | 1054 | abril | 1 | |
| Argentina | 1133 | abril | 2 | 79 |
| Argentina | 1265 | abril | 3 | 132 |
| Argentina | 1451 | abril | 4 | 186 |
| Argentina | 1451 | abril | 5 | 0 |
| Argentina | 1554 | abril | 6 | 103 |
| Argentina | 1628 | abril | 7 | 74 |
| Argentina | 1715 | abril | 8 | 87 |
| Argentina | 1795 | abril | 9 | 80 |
i need to create the column "casos por dia" in power bi con dax, the column must be a daily grow, so the difference between a day and the day before, must work for many countrys , months and year, the date can be change to any format.
i need to do it in dax to publish in power bi, the data come from the cloud
Hi Anonymous
You will need to make sure that you have one column for Date. I create a sample data model with the following columns:
- Country
- Date
- Amount
I then created two more columns called DateBefore (which is the previous day's date) and Change (which is the change from previous day). Please see the screenshots below for the DAX expression for those 2 new columns.
Hope this help!
If I have answered your questions please Accept this post as a solution!
6 Replies
Hi Anonymous
You will need to make sure that you have one column for Date. I create a sample data model with the following columns:
- Country
- Date
- Amount
I then created two more columns called DateBefore (which is the previous day's date) and Change (which is the change from previous day). Please see the screenshots below for the DAX expression for those 2 new columns.
Hope this help!
If I have answered your questions please Accept this post as a solution!
Anonymous I would beg to differ. There is no written law which says what tool should be used for what calculation. At the end of the day it comes down to personal preference 🙂
- bheepatel, I beg to differ. Calculated columns are never compressed optimally by the SSAS engine, therefore if you want to get the best of your model in terms of space and speed, you'd better use Power Query.
What's more, DAX has no concept of order whereas Power Query, the M language, does. Hence calculations like yours should be performed in PQ.
Best
D