Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
vinodDrinkPak
Helper II
Helper II

Rolling average

Hi Experts

 

below is matrix visual in power bi where i have used rows as customer and coloumns as month and dax

Average_Total_CEs =
IF(
    ISBLANK(AVERAGE('CE Per Pallet'[Total CEs])),
    0,
    AVERAGE('CE Per Pallet'[Total CEs])
)

 

vinodDrinkPak_0-1708149449368.png

Now the requirement was to calculate the rolling average for which i used Chat gpt for the measure

 

Rolling_Average_Total_CEs =
VAR SelectedCustomer = SELECTEDVALUE('CE Per Pallet'[Customer Name])
VAR CurrentMonth = SELECTEDVALUE('CE Per Pallet'[EOM])

RETURN
IF(
ISBLANK([Average_Total_CEs]),
0,
AVERAGEX(
FILTER(
ALL('CE Per Pallet'),
'CE Per Pallet'[Customer Name] = SelectedCustomer &&
'CE Per Pallet'[EOM] <= CurrentMonth
),
[Average_Total_CEs] 
)
)

 

but looks like the outcome is not right, so for example 0+69/2, should be 34.5?

Screenshot 2024-02-17 113405.png

 

1 REPLY 1
Ashish_Mathur
Super User
Super User

Hi,

Share the download link of the PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.