Forum Discussion
Solved
Multiplying a column based on slicer
Hi, I have a data model where I have a day in the year and a certain utlization in one table. For example Day 1 = 0.4, Day 2 = 0.6. Now I also have a table which lists values between 1 and 15. I ...
Matthias93,
The value of Day 2 should be 2.4(4*0.6), right? If so, I make a test in the following sample tables.
Create the following measure in the first table.multiplyMeasure = MAX(Table2[Column1])*MAX(Table1[Column1])
Create a table visual and test the slicer.
Regards,
LydiaHi Lydia,
This is exactly what I needed for my dashboard. Thanks for your quick help, I'll try to apply it to my case now.
Kind regards,
Matthias
Hi Lydia,
This is exactly what I needed for my dashboard. Thanks for your quick help, I'll try to apply it to my case now.
Kind regards,
Matthias
Matthias93,
If the above reply solves your issue, please accept my reply as answer to close this thread.
Regards,
Lydia