Capture grand Total Snapsots in PowerBI as table/display as table

[kalwabharath44]

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

[Greg_Deckler]

@kalwabharath44 - Can't think of a native way to do that except perhaps uisng Power Automate or an add-on like PowerOn.

[kalwabharath44]

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