Forum Discussion

Morran's avatar
Morran
Icon for Helper I rankHelper I
3 years ago
Solved

Avoid Recurring Value in Table

Hello, everyone. Sorry for interrupting your time, I'd like to ask a question. I'm dealing with the allocation resources problem and I'd like to visualize a summary in the table form. However, my tab...
Need Help
  • danextian's avatar
    danextian
    3 years ago

    Hi Morran ,

     

    I modified the pbix a bit to check for any duplicate Material + Deficit Qty because the merging in Power Query can cause duplicates as in the screenshot below.

    The updated logic now returns defici qty only for the first instance.

     

Morran's avatar
Morran
Icon for Helper I rankHelper I
3 years ago

Hi danextian , Would you mind to share your PBIX file? I think that one is great.

Regards,
Morran

danextian's avatar
danextian
Icon for Super User rankSuper User
3 years ago

Hi Morran ,

 

I modified the pbix a bit to check for any duplicate Material + Deficit Qty because the merging in Power Query can cause duplicates as in the screenshot below.

The updated logic now returns defici qty only for the first instance.