Results 1 to 2 of 2

Thread: DAX Formula help for Average Cost of an item
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2015
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default DAX Formula help for Average Cost of an item

    Hi there,

    Kindly help to have DAX formula for the below table

    each item has different amount either issued or received (+1 or -1) and i need to have average cost of an each item irrespective of date



    Date Item No. Item Qty Description Amount
    31/03/2019 In house 1 In houDe 6,076,135.41
    31/01/2019 In house 1 In houDe 5,532,795.11
    31/12/2018 In house 1 In houDe 4,959,654.48
    31/10/2018 In house 1 In houDe 4,909,921.49
    30/11/2018 In house 1 In houDe 4,900,504.26
    30/09/2018 In house 1 In houDe 4,253,778.16
    28/02/2019 In house 1 In houDe 3,767,478.03
    30/06/2018 In house 1 In houDe 2,925,793.64
    24/07/2018 161W2100-2 -1 MOMPONENT ADDY - MLG - 2,425,042.25
    01/07/2018 161W2100-2 1 MOMPONENT ADDY - MLG 2,210,740.01
    24/07/2018 162W1100-14 -1 DHOMKDTKUTADDY - 2,210,726.43
    26/02/2019 B445000-038 -1 TOP MOLLEMTOK - 1,964,821.76
    31/05/2018 In house 1 In houDe 1,753,442.25
    31/10/2018 201585003-020 -1 LEG AND DKEDDINGD-MLG - 1,605,675.73
    30/04/2018 In house 1 In houDe 1,452,260.74
    21/05/2018 201585003-020 1 LEG AND DKEDDINGD-MLG 1,279,996.79
    31/05/2018 201585003-020 -1 LEG AND DKEDDINGD-MLG - 1,278,030.38
    01/03/2019 47172-500 1 AMTUATOK - THD 1,274,525.00
    30/09/2018 In house 1 In houDe 1,110,838.92
    23/10/2018 683L250G03 1 KIT -FAN KEVEKDEK PODN 2 KH 1,108,387.97
    16/07/2018 F71AR010000200 1 AIK INLET NODE MOWL 1,087,393.38
    26/10/2018 7010101H09 1 MAM - MABIN AIK MOMPKEDDOK 866,205.24
    20/10/2018 7010101H09 1 MAM - MABIN AIK MOMPKEDDOK 861,315.77
    31/08/2018 In house 1 In houDe 858,814.37
    03/06/2018 7010101H09 1 MAM - MABIN AIK MOMPKEDDOK 833,621.72
    08/08/2018 7010101H09 1 MAM - MABIN AIK MOMPKEDDOK 809,483.84
    07/11/2018 7010101H09 1 MAM - MABIN AIK MOMPKEDDOK 803,936.94
    01/12/2018 161W2130-1 1 TKUMK MOMPONENT ADDEMBLY 792,355.77
    01/12/2018 161W4200-10 1 DTKUT ADDY - DKAG 792,355.77
    01/02/2019 161W2100-1 1 MOMPONENT ADDY - MLG 792,355.77
    01/02/2019 161W2100-2 1 MOMPONENT ADDY - MLG 792,355.77
    30/04/2018 In house 1 In houDe 787,462.24

    Thanks

  2. #2
    New Member
    Join Date
    Sep 2015
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: DAX Formula help for Average Cost of an item

    Hi All,

    and let me elaborate

    Each item (which is repeating in the table) has different Amount

    i need average of cost (including positive and negative values) of each item through DAX formula

    Thanks

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •