Forum Discussion
Solved
Need Help - Duplicate rows issue
We have a requirement in power BI to create a tabular visual with columns from table A (id,status,type,value) and columns from table B (S_Opening_date,S_Closer_date) For this I need to create two ca...
Hi rnagallatav ,
Here are the steps you can follow：
1. Enter the power query, Home – Merge Queries – Merge Queries as new – Left Out.
Result:
2. Create calculated column.
Index = IF( 'Merge1'[Table B.attribute Title]=BLANK()&&'Merge1'[Table B.attribute value]=BLANK(),0, RANKX(FILTER(ALL(Merge1),'Merge1'[ID ]=EARLIER('Merge1'[ID ])&&'Merge1'[Status ]=EARLIER('Merge1'[Status ])),[Table B.attribute value],,DESC,Dense))3. Put [Index] in Filter, is=1.
4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi rnagallatav ,
Here are the steps you can follow：
1. Enter the power query, Home – Merge Queries – Merge Queries as new – Left Out.
Result:
2. Create calculated column.
Index =
IF(
'Merge1'[Table B.attribute Title]=BLANK()&&'Merge1'[Table B.attribute value]=BLANK(),0,
RANKX(FILTER(ALL(Merge1),'Merge1'[ID ]=EARLIER('Merge1'[ID ])&&'Merge1'[Status ]=EARLIER('Merge1'[Status ])),[Table B.attribute value],,DESC,Dense))
3. Put [Index] in Filter, is=1.
4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly