Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

MOVING AVERAGE

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.