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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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 |