Forum Discussion
Helper IAverage Dax
Helper IIt doesn't work.
Dax command has some error, so I put "SUM" infromt of 'Test'[Nov]
Community SupportHi nanacobsbs ,
can you try the below Dax query :
RunningAverage =
IF(
HASONEVALUE('Test'[DATE]),
AVERAGEX(
FILTER(
ALL('Test'[DATE]),
'Test'[DATE] <= MAX('Test'[DATE])
),
'Test'[Nov]
),
AVERAGEX(
ALL('Test'[DATE]),
'Test'[Nov]
)
)
If the issue persists share the sample date for better understanding.
If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!
- v-aatheeque
Hi nanacobsbs ,
We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.
If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!Thank you!
- v-aatheeque
Hi nanacobsbs ,
Has your issue been resolved? If a community member's response addressed your query, please consider marking it as Accepted Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!- v-aatheeque
Hi nanacobsbs ,
We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.
If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!Thank you!
- nanacobsbs
Thank you for your comment.
I tried above DAX command, but it doesn't work like below.
- v-aatheeque
Hi nanacobsbs,
can you try this :
Average Display =
IF (
ISINSCOPE('Test'[Date]),
CALCULATE(AVERAGE('Test'[Nov])),
CALCULATE(MAXX(VALUES('Test'[Date]), CALCULATE('Test'[Nov])))
)If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
- nanacobsbs
Thank you for your comment.
I tried above DAX command, but it doesn't work like below.
If the total had shown 26.77 it would have been good.