PowerBI Data

[Anonymous]

I have a data for incidents and for the Critical Incident I have data for the next months Jan, Feb, Mar, Apr but for May, Jun, Jul and Agu I don't have any register for Critical Incident, How I can complete those month May, Jun, Jul, Agu and other months with (0)?

I appreciate your help

[v-angzheng-msft]

Hi, @Anonymous 

How would you like to calculate the average for a month with no Critical Incident in that month?
Make the average 0? Make the average equal to the last month with an Critical Incident? Divide the sum of Critical Incident by the total number of months?
What is your formula for calculating the average? Can you please elaborate on what you are trying to achieve or post sample data and expected result so it is clear on what needs to be implemented?

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello Thank you very mucho for your post

for the calculation of the Average I use those Mesures:

1B-ACUM-PROM =

CALCULATE(

DIVIDE([1B-Acumulado],COUNTROWS(VALUES(Cervello[Fecha de resolución del ticket Mes]))),

FILTER(

ALLSELECTED(Cervello),

Cervello[Fecha de resolución del ticket Mes] <= MAX(Cervello[Fecha de resolución del ticket Mes])

)

)

1B-Acumulado =

CALCULATE(

SUMX(VALUES(Cervello[Fecha de resolución del ticket Mes]),[1A-SUMA-PROM]),

FILTER(

ALLSELECTED(Cervello),

Cervello[Fecha de resolución del ticket Mes] <= MAX(Cervello[Fecha de resolución del ticket Mes])

1A-SUMA-PROM =

VAR X = DIVIDE(AVERAGE(Cervello[TTTRWH]),COUNTROWS(VALUES(Cervello[Fecha de resolución del ticket Mes])))

Return

SUMX(VALUES(Cervello[Fecha de resolución del ticket Mes]),x)

)

)

In the next Image you will see the 3 mesures in the table, is important that you know in the table is filtered by Year, and Incident Priority, so for the month JAN, FEB, MAR, APR it has register for Incidente with Critical Incidente but for the next monts like JUN, JUL and AGU in the data base don't register any Critical Incident but the average must be calculated but if don't have any data don't calculate de Average.

[mussaenda]

Hi @Anonymous ,

Do you have a date table?

[Anonymous]

No I don't

[Tahreem24]

@Anonymous , I believe you need to create New Calendar table using below DAX:

New Calendat Table =
VAR myDate = Min(TableName[DateColumn])
RETURN CALENDAR(myDate,DATE(YEAR(myDate),12,31)

[Anonymous]

Thank you verymuch in this, so after that what is the next step, I mean that i need to calculate the time average of resolution of the critical incidents, in the moment i have this

If you see the image I can calculate the average until April (see orange line) but I can't calculate the average for the next nonths because there are not Critical Incident, but for my knowlage I must calculate the average for the rest of the months.