Forum Discussion
Anonymous
2 years agoNot applicable
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.
1 Reply
- Greg_DecklerCommunity Champion