Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Is there a Way to capture grand Total Snapsots in PowerBI?
i have two column
1. Warning Level
3. Employee Count
Need to get a snapshot of grand totaly everyday and store/display as table.
Ex:
Warning Level(Text Column) | Level 1 | Level 2 | Level 3 | Level 4 | N/A |
2/18/2021 | Count of Employee ID(Grand Totals) | Count of Employee ID(Grand Totals) | Count of Employee ID(Grand Totals) | Count of Employee ID(Grand Totals) | Count of Employee ID(Grand Totals) |
2/19/2021 | 2 | 6 | 4 | 5 | 20 |
2/20/2021 | 2 | 7 | 4 | 7 | 20 |
2/21/2021 | 4 | 7 | 8 | 7 | 24 |
2/22/2021 | 4 | 7 | 8 | 9 | 26 |
2/23/2021 | 6 | 7 | 10 | 9 | 30 |
2/24/2021 | 6 | 7 | 10 | 10 | 32 |
2/25/2021 | 10 | 7 | 14 | 10 | 34 |
2/26/2021 | 10 | 7 | 14 | 10 | 36 |
2/27/2021 | 12 | 7 | 14 | 10 | 40 |
@kalwabharath44 - Can't think of a native way to do that except perhaps uisng Power Automate or an add-on like PowerOn.
Thankyou for your response Greg, can you please provide me an example on how to implement this using Power Automate ? Never did a flow connected to PowerBI
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
47 | |
28 | |
25 | |
17 | |
17 |