Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi,
Need help in creating a new column where i can get the value by date. Currently i have the incremental value need help in converting to daily.
whats your expected result based on you example for US?
hello,
Below Daily Value colum is what i need to generate, I hope I am clear
| Country | Date | Value | Daily Value |
| Japan | 1/22/2020 | 2 | 2 |
| India | 1/22/2020 | 1 | 1 |
| Japan | 1/23/2020 | 5 | 3 |
| Japan | 1/24/2020 | 5 | 0 |
| India | 1/24/2020 | 2 | 1 |
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 13 | |
| 8 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 29 | |
| 19 | |
| 18 | |
| 11 | |
| 10 |