Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Maxigut1
New Member

Formulas in a Matrix

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))

 

Pwer BI exapmle.png

 

I really appreciate your help.

 

Thanks & Regards,

1 ACCEPTED SOLUTION
v-caliao-msft
Microsoft Employee
Microsoft Employee

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])

 

 

Capture.PNG

 

Regards,

Charlie Liao

View solution in original post

1 REPLY 1
v-caliao-msft
Microsoft Employee
Microsoft Employee

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])

 

 

Capture.PNG

 

Regards,

Charlie Liao

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.