We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
Hello, I created a dax formula to find out the previous month's data:
These data are percentages. But in the total row of my table, I have a percentage sum and not an average. Can you help me? THANKS.
Solved! Go to Solution.
Hey!
I think if you create a weighted average it should work, try using this formula instead: Detention_Tx_Avg = AVERAGEX( Detention, Detention[TX_DETENTION_JOUR] )
This formula will make sure it is not a sum of all averages.
Hope this helps!
Zoe 😁😁
It's OK! Thank you!!
Thank you!!!
Hey!
I think if you create a weighted average it should work, try using this formula instead: Detention_Tx_Avg = AVERAGEX( Detention, Detention[TX_DETENTION_JOUR] )
This formula will make sure it is not a sum of all averages.
Hope this helps!
Zoe 😁😁
User | Count |
---|---|
64 | |
59 | |
46 | |
35 | |
32 |
User | Count |
---|---|
85 | |
85 | |
70 | |
51 | |
46 |