Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Randy Etheridge]

I have column of data.  it is a fixed days calculation.  so it takes the resolved date, subtracts the open date and gives an integer day value back

1
2
3
4
5
6
7
etc
I need an average of the days 4 – 30 only
not sure the formula

thinking something like this

Avg4_30Days = Averagex(FILTERs(incidents_av[sladays],between 4 and 30))

any help is appreciated.  thank you.

——————————
Randy Etheridge
Veritiv Corporation
P&F USA Inc
Torrance CA
770-315-9670
——————————

[Adam Artur Boltryk]

Hi Randy,

Avg4_30Days =

CALCULATE(
       AVERAGE([Column_To_Calculate]),
       [sladays]>4 && [sladays]<30
       )

Regards,

——————————
Adam Artur Boltryk
Business Analyst
——————————
——————————————-

[Randy Etheridge]

ok so I did this

Avg4_30days = CALCULATE(Average(incidents_av[sladays]),[sladays]>=4&&[sladays]<=30)

so my column containing the days is SLAdays.  the error message says the [Sladays] in the 4 to 30 statement is not valid.

I am playing with it, but so far nothing, but thanks for the additional information.

——————————
Randy Etheridge
Veritiv Corporation
P&F USA Inc
Torrance CA
770-315-9670
——————————
——————————————-

[Randy Etheridge]

just one more comment the view that PowerBI is using is incidents_av

one of the columns of data is SLAdays (calculated in the view)

——————————
Randy Etheridge
Veritiv Corporation
P&F USA Inc
Torrance CA
770-315-9670
——————————
——————————————-

[Randy Etheridge]

never mind typo, works perfect thanks

——————————
Randy Etheridge
Veritiv Corporation
P&F USA Inc
Torrance CA
770-315-9670
——————————
——————————————-