Forum Discussion
Change different multiplier when different date
Hi, primolee
Please check the below picture and the sample pbix file's link dow below.
I created both measures and columns.
All measures and created columns are in the sample pbix file.
https://www.dropbox.com/s/5bhb72jux254dxl/primolee2.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
Hello Jihwan_Kim ,
Thank you again for your help. Greatly appreciated!
To further extend the question. Because we have different weight values for different people, is it possible to have a filter visual in the report, choose a person's weight setting, then calculate the weighted spending?
In this case, I have 1 more column as Name, just as John and Peter, and each of them have their weight setting. Then make a name filter in the report.
Thank you very much.
Best regards,
David
Hi, primolee
Thank you for your feedback.
I am not sure how to create the person's name column, but I just simply created it to show as a table visualization.
Please check the below picture and the link down below, whether it is what you are looking for.
https://www.dropbox.com/s/5bhb72jux254dxl/primolee2.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
Hello Jihwan_Kim ,
Thank you so much for your prompt reply.
This is what I meant, add a "Name" column to the weight table. Then use filter visual to single select name.
Column will not work, but measure seems to work fine.
https://drive.google.com/file/d/1BcFHRkQFESSs-T_hcYMl0XmBndZp5vVN/view?usp=sharing
Thank you once again for your help!
Best regards,
David