Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
i have table name called Master file.My data table looks like below. i want compare the values .if IN_table ,Out_Table ,Eo_In_table , Eo_Out_table ,CMN all same its return TRUE . if Not matached N_table ,Out_Table ,Eo_In_table , Eo_Out_table ,CMN its return False.
ID Columnztype IN_table Out_Table Eo_In_table Eo_Out_table Year CMN
11 Adjustable_Shipment 0 0 0 0 2021 0
11 Adjustable_Shipment 0 0 0 0 2022 0
11 Fixed_Shipment 326280 326280 326280 326280 2021 326280
11 Fixed_Shipment 1017720 1017720 1017720 1017720 2022 1017720
11 Fixed_PLB 36021816 36021816 36021816 36021816 2021 65029906
11 Fixed_PLB 40041259 40041259 40041259 40041259 2022 41468899
Expected Output looks like
ID Columnztype IN_table Out_Table Eo_In_table Eo_Out_table Year CMN Status
11 Adjustable_Shipment 0 0 0 0 2021 0 True
11 Adjustable_Shipment 0 0 0 0 2022 0 True
11 Fixed_Shipment 326280 326280 326280 326280 2021 326280 True
11 Fixed_Shipment 1017720 1017720 1017720 1017720 2022 1017720 True
11 Fixed_PLB 36021816 36021816 36021816 36021816 2021 65029906 False
11 Fixed_PLB 40041259 40041259 40041259 40041259 2022 41468899 Fasle
i have tired below measure getting Error :
what mistake i did? looking for support . thanks in advance.
Solved! Go to Solution.
Hi,
Here is a pretty straightforward way to do this (albeit not the most elegant):
End result:
I hope this helps and if it does consider accepting this as a solution and giving the post a thumbs up!
Proud to be a Super User!
Hi,
Here is a pretty straightforward way to do this (albeit not the most elegant):
End result:
I hope this helps and if it does consider accepting this as a solution and giving the post a thumbs up!
Proud to be a Super User!
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |