Data Tranformation

[KuntalSingh]

Hi Team,

I have data in the mention below formate. Can you please help me how to transform this data to get the visulisation count by user on date selected from the date slicer .

SAP IDNamesLOBWorking DayMonthly Target 1-Feb-232-Feb-233-Feb-234-Feb-235-Feb-236-Feb-237-Feb-238-Feb-239-Feb-2310-Feb-2311-Feb-2312-Feb-2313-Feb-2314-Feb-2315-Feb-2316-Feb-2317-Feb-23

UCON900030	Sanjay Thakur	PO Condition	19	2441	130	120	132	0	0	140	130	130	122	127	0	0	130	130	34	95	130
UCON900004	Garima Lawania	PO Condition	19	2550	130	120	130	0	0	0	130	130	122	130	0	0	146	130	109	95	130
UCON900006	Kanupriya Chauhan	PO Condition	18	2437	130	120	130	0	0	138	0	130	122	130	0	0	130	130	132	120	130
UCON900035	Anju Barthwal	PO Condition	19	2534	130	120	130	0	0	138	130	130	0	130	0	0	130	127	103	95	130
UCON900010	Ankita Kumari	PO Condition	20	2660	130	120	130	0	0	138	130	130	122	130	0	0	130	130	104	95	130
UCON900046	Anmol Jain	PO Condition	19	2459	130	0	130	0	0	130	105	130	122	130	0	0	130	130	106	95	130
UCON900029	Shweta Bali	PO Condition	19	2488	105	75	120	0	0	138	130	130	121	130	0	0	0	130	120	120	127
UCON900064	Shubham Chaudhary	PO Condition	20	2661	130	120	130	0	0	138	130	130	122	130	0	0	130	130	104	95	130
UCON900013	Shivani Gupta	PO Condition	17	2120	130	120	120	0	0	138	130	130	122	130	0	0	0	107	32	95	130
UCON900049	Binti Saran	PO Condition	18	2316	130	120	130	0	0	138	130	130	100	130	0	0	130	113	104	95	130
UCON900023	Amit Kumar Jha	PO Condition	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
UCON900024	Kishan Kumar	Validation	18	2420	130	130	130	0	0	130	130	130	130	130	0	0	130	140	140	130	0
UCON900043	Shailesh Jha	Validation	20	2690	130	130	130	0	0	130	130	130	130	130	0	0	130	140	140	130	130
UCON900044	Jigar Kalra	Validation	20	2630	130	130	130	0	0	130	130	130	130	130	0	0	130	130	130	130	130
UCON900008	Vinay Sehgal	Validation	20	3350	200	70	80	0	0	210	210	210	210	210	0	0	230	240	240	130	130
UCON900039	Shweta Yadav	Validation	20	2630	130	130	130	0	0	130	130	130	130	130	0	0	130	130	130	130	130
UCON900040	Monika	Validation	20	2630	130	130	130	0	0	130	130	130	130	130	0	0	130	130	130	130	130
UCON900037	Mansi Reswal	Validation	14	1850	130	130	130	0	0	0	0	0	0	0	0	0	130	130	130	130	130
UCON900038	Raghvendra Mishra	Validation	13	1690	130	130	130	0	0	130	130	130	0	0	0	0	130	140	140	130	130
UCON900050	Basram Choudhary	Validation	20	2620	130	130	130	0	0	130	130	130	130	130	0	0	130	140	140	130	130
UCON900003	Bipin Rai	Validation	17	2250	130	130	130	0	0	130	130	130	130	130	0	0	130	140	140	130	130
UCON900059	Aman Soni	Validation	20	2630	130	130	130	0	0	130	130	130	130	130	0	0	130	130	130	130	130
UCON900051	Kumar Gyan Vardhan	Validation	18	2210	120	120	120	0	0	120	120	120	120	120	0	0	120	120	120	130	120
UCON900063	Naveen Gupt	Validation	8	1050	130	130	130	0	0	130	0	0	0	0	0	0	0	0	0	0	0
UCON900034	Amritesh Mishra	Validation	17	2240	130	130	130	0	0	130	130	130	130	130	0	0	130	130	130	0	0
UCON900025	Abul Shoaib	Validation	1	130	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	130	0
UCON900065	Ashok Singh	Validation	8	840	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	100	100
UCON900048	Varun Gupta	VIM Exception	15	1635	128	147	148	0	0	135	100	98	86	110	0	0	0	17	130	130	110
UCON900031	Shivam Gupta	VIM Exception	19	2679	130	140	140	0	0	138	140	131	116	103	0	0	0	40	150	140	140
UCON900045	Neetu Rawat	VIM Exception	20	2663	133	141	138	0	0	157	134	130	120	133	0	0	6	41	143	140	158
UCON900042	Komal Rawat	VIM Exception	19	2439	128	142	148	0	0	152	138	130	123	135	0	0	5	51	144	140	140
UCON900033	Jitesh Tandon	VIM Exception	19	2460	141	151	140	0	0	211	128	133	102	101	0	0	10	28	142	140	140
UCON900041	Ayush Garg	VIM Exception	15	1587	142	131	140	0	0	203	100	76	103	0	0	0	8	9	134	134	110
UCON900007	Shivani Choudhary	VIM Exception	16	1784	138	121	141	0	0	141	102	100	82	101	0	0	86	44	130	139	110
UCON900032	Disha Satija	VIM Exception	19	2405	130	140	140	0	0	136	130	124	130	130	0	0	27	15	140	140	0
UCON900061	Rishabh Srivastava	VIM Exception	16	1989	122	142	142	0	0	146	117	130	130	130	0	0	18	36	148	139	140
UCON900036	Nancy Garg	VIM Exception	19	2689	146	149	144	0	0	146	148	143	134	137	0	0	0	18	151	140	140
UCON900005	Shubham Sagar	VIM Exception	20	2703	140	125	140	0	0	140	113	121	131	120	0	0	10	50	129	149	140
UCON900015	Neha Kumari	VIM Exception	16	2003	132	168	128	0	0	128	126	129	124	51	0	0	0	3	149	139	140
UCON900066	Ankit Kothari	VIM Exception	12	1515	0	0	0	0	0	0	0	0	0	0	0	0	14	20	154	140	145
UCON900009	Kanika Sharma	VIM Exception	14	1846	0	0	0	0	0	0	0	70	121	107	0	0	0	40	145	140	140
UCON900052	Mamta Rawat	VIM Exception	8	949	130	142	140	0	0	136	87	129	107	78	0	0	0	0	0	0	0
UCON900062	Puja Gupta	VIM Exception	18	2318	133	0	124	0	0	133	112	130	120	126	0	0	0	11	140	140	140

[v-shex-msft]

Hi @KuntalSingh,

You can do unpivot columns on these date fields, then you can simply use unpivoted date values as source of slicer to filter and summary table records:

Unpivot columns - Power Query | Microsoft Learn

Regards,

Xiaoxin Sheng

[KuntalSingh]

Hi Xiaoxin,

Thanks for your kind support.

I treid this but it throws an error of duplicate records and due to this I am not able to save the changes 

[v-shex-msft]

Hi @KuntalSingh,

It seems like the unpivot column operation change the table structure and it affect the table relationship analysis.
Perhaps you can duplicate the table to create a copy for these operations and visual designs, this new table should not affect the raw table relationship mappings.

Regards,

Xiaoxin Sheng