SalesGrouping With Customercode and Amount month Wise

[bilalkhokar73]

SalesGrouping With Customercode and Amount month Wise

I need to do sales gropuing on amount

in value need distinct customer code and with amount ,I want to do filter also with user table and date table , but i am unable to achive this,

0-100    

100-200

300-400

I have attached my files here 

we trasnfer https://we.tl/t-gGssUq3xNR
Desired results -

@amitchandak 

[v-henryk-mstf · Accepted solution]

Hi @bilalkhokar73 ,

Try formula like below:

m =
CALCULATE (
    SUM ( raw[InNA] ),
    ALLEXCEPT ( 'date', 'date'[year_id], 'date'[mont_id] ),
    ALLEXCEPT ( Rawdata, Rawdata[SVGRoupnewtab] ),
    raw[ORDER_TYPE] == "SALES_ORDER"
)

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.