Need urgent help on creating a report

[b3nkumar]

Can anyone please help how I can reach to the output:-

Please refer data and output detail as below:-

	Data
		Balance1	Balance2	Metrics1	Metrics2
Friday	4/14/2023	1000	2000	10	20
Monday	4/17/2023	1001	20001	11	21
Tuesday	4/18/2023	1002	20002	12	22
Wednesday	4/19/2023	1003	20003	13	23
Thursday	4/20/2023	1004	20004	14	24
Friday	4/21/2023	1005	20005	15	25
Monday	4/24/2023	1008	20008	18	28
Tuesday	4/25/2023	1009	20009	19	29
Wednesday	4/26/2023	1010	20010	20	30
Thursday	4/27/2023	1011	20011	21	31
Friday	4/28/2023	1012	20012	22	32
	Output
		Balance1 Delta	Balance2 Delta	Metrics1 delta	Metrics2 delta
	4/28/2023	1012	20012	22	32
	4/27/2023	1011	20011	21	31
	current vs Prior	1	1	NA	1
	vs Base	NA	NA	6	7
	6 is resultant of delta from a static table value
	7 is resultant of delta from a statis table value
	NA is columns where delta are not required
	only latest 2 dates data should be populated and delta between these but only for Weekdays/Non Holiday data

[Anonymous]

Hi @b3nkumar ,

The output you want looks like a matrix visual. However, I think latest 2 dates should come from [Date] column. So [Current vs Prior] and [vs Base] should be separate measures. I think they couldn be show in same field with your current data model.

If you want to calculate latest two days without weekends/holidays, you can create a calendar table with continuous dates and determind the days in it.

For reference:

Use DAX to create a calendar table with holidays - Microsoft Power BI Community

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.