Forum Discussion

superpowerteam's avatar
superpowerteam
Frequent Visitor
3 years ago

Running Total for an Average Dax Measure.

Hi guys,  I am getting nuts, about this litte problem and I think you experts outside know the answer very fast.    My dataset:     I created a measure which uses the Week-Offest from the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi superpowerteam ,

Please have a try. Modify the measure.

rt avg =
VAR reihenfolge =
    SELECTEDVALUE ( DimDates[Days of week number] )
RETURN
    SUMX (
        FILTER (
            ALLSELECTED ( DimDates ),
            DimDates[Days of week number] <= reihenfolge
        ),
        [AVG 12 Weeks]
    )

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

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

superpowerteam's avatar
superpowerteam
Frequent Visitor
3 years ago

Hi, 

thank you for the code. Unfortunately you code is not working. As you can see your code delivers the result which I marked with the red cross. The result should be as  you can see in the prepared column. 

 

Any other ideas?