SOLVED

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)
Solution

@TomF1212 

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.