Forum Discussion
Create a calculation based on two tables
Hi Anonymous
Please check the measures in attachment.
AC Power Rate = DIVIDE ( CALCULATE ( SUM ( Individual[Amount] ), Individual[Department] = "AC POWER" ), CALCULATE ( SUM ( Total[Total] ), FILTER ( ALL ( Total ), Total[Department Total] = "AC POWER" && Total[Date] <> "NOV C18" ) ) )Regards,
Cherie
Microsoft EmployeeHi Anonymous
Please check the measures in attachment.
AC Power Rate =
DIVIDE (
CALCULATE ( SUM ( Individual[Amount] ), Individual[Department] = "AC POWER" ),
CALCULATE (
SUM ( Total[Total] ),
FILTER (
ALL ( Total ),
Total[Department Total] = "AC POWER"
&& Total[Date] <> "NOV C18"
)
)
)
Regards,
Cherie
Almost! haha however, how am I suppose to make the calculation such that the totals will only be for a selected date range? ex. the total should be the sum from Nov 2017 - Oct 2018???
Apologies for having to many questions about this and thank you for helping me on this.
- v-cherch-msft
Hi Anonymous
What is a selected date range? You want to add a slicer to get the dynamic date range?If so,you may refer to below post to get the last 12 month values from selected month.
Regards,
Cherie
Hello v-cherch-msft
Your samples are very helpful. I will look into your suggestions. Thank you so much!
- v-cherch-msft
Hi Anonymous
Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.
Regards,
Cherie