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 dat...
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.

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.