The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
6 |