Forum Discussion

keen's avatar
keen
Frequent Visitor
2 years ago
Solved

Average calculation needed

Hi Team,  this is yearly sales . i create a measure with divide 12 months . average for FY2023 is correct. But in fact 2024 sales is 6 months data only. Just wondering how to count FY2024 total sales / 6 months without affect my FY2023 ?Please advice me what is the best way. Thank You.

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi keen ,

     

    I made simple samples and you can check the results below:

    AVG = var _t = ADDCOLUMNS('Table',"count",COUNTX(FILTER(ALL('Table'),[year]=EARLIER([year])&&[Total]<>BLANK()),[Month]))
return AVERAGEX(_t,[Total]/[count])

     

    An attachment for your reference. Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi keen ,

     

    I made simple samples and you can check the results below:

    AVG = var _t = ADDCOLUMNS('Table',"count",COUNTX(FILTER(ALL('Table'),[year]=EARLIER([year])&&[Total]<>BLANK()),[Month]))
return AVERAGEX(_t,[Total]/[count])

     

    An attachment for your reference. Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

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

    • keen's avatar
      keen
      Frequent Visitor
      2 years ago

      The total sales i have linked with a date table . Relationship is creation date (*) linked with date (1) .

      The formula sharing is not suitable . Thanks for your sharing.