Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I'm tottaly newby in DAX and need certainly help for a basic commands.
I've got a Matrix that show the data consumption for each mobile subscription, I would like to create a new column to show the average of the data comsuption.
To built my matrix, I've got 2 tables.
- DATAs_Vol_Mob
Period | Subscription | DATA Volume |
1.2024 | 4179xxxyy01 | 8935.663 |
1.2024 | 4179xxxyy02 | 8301.548 |
2.2024 | 4179xxxyy01 | 9035.663 |
2.2024 | 4179xxxyy02 | 8401.548 |
2.2024 | 4179xxxyy01 | 9035.663 |
3.2024 | 4179xxxyy02 | 8386.548 |
- Inventaire_Mobile
Contrat lié | Référence du contrat | Utilisateur (login) |
4179xxxyy01 | NATEL® go flex Swiss premium XS | USER#1 |
4179xxxyy02 | NATEL® go flex Swiss premium M | USER#2 |
A link between the 2 tables in
The result I want should be :
Utilisateur (login) | Référence du contrat | Subscription | 1.2024 | 2.2024 | 3.2024 | TOTAL | Average [based on all period] | Average of the data consumption of all subscrption of the "Reference du contrat) |
USER#1 | NATEL® go flex Swiss premium XS | 4179xxxyy01 | 8935.663 | 9035.663 | 9035.663 | 27006.99 | 9002.33 | ? |
USER#2 | NATEL® go flex Swiss premium M | 4179xxxyy02 | 8301.548 | 8401.548 | 8386.548 | 25089.64 | 8363.21 | ? |
Average [based on all period] = Average of the 3 current period (1.2024 | 2.2024 | 3.2024). Next periods will be added later on.
Last column should be the average of all subscription per "reference contrat" as I have ~1500 subsriptions.
I tried to use "Quick Mesure" but the result is not the one I want.
I want also update all month the data for the current period, as I will run this repport on a long terms, having average per year will be a must.
Thanks for your futur support
Solved! Go to Solution.
Based on what you wrote I think you are looking for something like this...
I have attached a pbix file that shows the measures I used.
Hope this gets you pointed in the right direction.
Proud to be a Super User! | |
Based on what you wrote I think you are looking for something like this...
I have attached a pbix file that shows the measures I used.
Hope this gets you pointed in the right direction.
Proud to be a Super User! | |
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |