Need urgent help on creating a report

Question

Can anyone please help how I can reach to the output:-Please refer data and output detail as below:-&nbsp;Data&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Balance1Balance2Metrics1Metrics2&nbsp;&nbsp;&nbsp;Friday4/14/2023100020001020&nbsp;&nbsp;&nbsp;Monday4/17/20231001200011121&nbsp;&nbsp;&nbsp;Tuesday4/18/20231002200021222&nbsp;&nbsp;&nbsp;Wednesday4/19/20231003200031323&nbsp;&nbsp;&nbsp;Thursday4/20/20231004200041424&nbsp;&nbsp;&nbsp;Friday4/21/20231005200051525&nbsp;&nbsp;&nbsp;Monday4/24/20231008200081828&nbsp;&nbsp;&nbsp;Tuesday4/25/20231009200091929&nbsp;&nbsp;&nbsp;Wednesday4/26/20231010200102030&nbsp;&nbsp;&nbsp;Thursday4/27/20231011200112131&nbsp;&nbsp;&nbsp;Friday4/28/20231012200122232&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Output&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Balance1 DeltaBalance2 DeltaMetrics1 deltaMetrics2 delta&nbsp;&nbsp;&nbsp;&nbsp;4/28/20231012200122232&nbsp;&nbsp;&nbsp;&nbsp;4/27/20231011200112131&nbsp;&nbsp;&nbsp;&nbsp;current vs Prior11NA1&nbsp;&nbsp;&nbsp;&nbsp;vs BaseNANA67&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6 is resultant of delta from a static table value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7 is resultant of delta from a statis table value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NA is columns where delta are not required&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;only latest 2 dates data should be populated and delta between these but only for Weekdays/Non Holiday data&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;b3nkumar&nbsp;,
&nbsp;
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&nbsp;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
&nbsp;
Best Regards,
Rico Zhou
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Need urgent help on creating a report

1 Reply

Related content

Fabric Create report API

Urgent ASAP: Paginated Report SubscriptionFailure-AdalExternalSecurityChallengeNotSatisfiedErrorCode

Urgent question about Policy update

Creating thin reports

Need Urgent Help on SamePeriodLastYear

	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