Forum Discussion

bilalkhokar73's avatar
bilalkhokar73
Icon for Helper IV rankHelper IV
3 years ago
Solved

SalesGrouping With Customercode and Amount month Wise

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 

Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    3 years ago

    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.

1 Reply

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    3 years ago

    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.