MOVING AVERAGE

[xFelipe12]

Good morning!

I have 2 columns in Power BI in a table called "Chamado". One is called "criado", which consists of dates, and the other is called "opçãodechamado". In the "opçãodechamado" column, it can return 3 text values: "PREVENTIVA", "CORRETIVA", and "MELHORIA".

A calendar dimension was created for this table. Consequently, I connected the "criado" column with the calendar dimension [data]. I need to calculate a moving average percentage of the total quantity of preventive work orders divided by the total quantity of work orders.

[Greg_Deckler · Accepted solution]

@xFelipe12 Better Rolling Average - Microsoft Fabric Community