Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Please I need help to solve the following issue because is ver important to improve my work. Is possible to calculate values from a Matrix?
I have a sales matrix summarized by Sales Department & by Day.
I need to calculate green & blue columns:
A- Green: 1- % Total sales variance from previous day.
2- Total sales of the day vs budget.
B-Blue: 3- Estimated month en close. (Acumulated amount+ Avereage sales * (Days in month-current day))
I really appreciate your help.
Thanks & Regards,
Solved! Go to Solution.
Hi @Maxigut1,
Yes, you can use the DAX below achieve you requirement.
Var.Vs Previous Day = (Matrix[Sum Departments]-LOOKUPVALUE(Matrix[Sum Departments],Matrix[Month Day],Matrix[Month Day]-1))/LOOKUPVALUE(Matrix[Sum Departments],Matrix[Month Day],Matrix[Month Day]-1)
Daily Total VS Daily Budget = Matrix[Sum Departments]-Matrix[Total Budget]
Estimated month end = Matrix[Acumulated]+(Matrix[Acumulated]/Matrix[Month Day])*(Matrix[Days in month]-Matrix[Month Day])
Regards,
Charlie Liao
Hi @Maxigut1,
Yes, you can use the DAX below achieve you requirement.
Var.Vs Previous Day = (Matrix[Sum Departments]-LOOKUPVALUE(Matrix[Sum Departments],Matrix[Month Day],Matrix[Month Day]-1))/LOOKUPVALUE(Matrix[Sum Departments],Matrix[Month Day],Matrix[Month Day]-1)
Daily Total VS Daily Budget = Matrix[Sum Departments]-Matrix[Total Budget]
Estimated month end = Matrix[Acumulated]+(Matrix[Acumulated]/Matrix[Month Day])*(Matrix[Days in month]-Matrix[Month Day])
Regards,
Charlie Liao
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |