Monetary unit sampling - Power Query

New Contributor

Hello community,


I would very much appreciate any help. I'm trying to create dynamic MUS report (monetary unit sampling). I need to filter each line in Excel (in attachment as Source table) that exceeds certain amount (Criteria) of accumulated value (in example Accumulation) and create a report only with this lines (in attachment as Report table). Is there a way to do it? So I need to filter all lines for which accumulation exceeds 150 in my case.MUS example.png

2 Replies
best response confirmed by TomF1212 (New Contributor)


accumulation 150.JPG

You can try the attached file which seems to return the expected result.

Thank you very much! Will try on my database.