Forum Discussion
Measure Conditional
This is very helpful.
In your original post, you said that you needed to multiply the sales price with the quantity. From the tables you shared, we can get a sales price for any given combination of Group/Date easily. How do you determine the quantity?
Sorry, I was wrong in saying that I want to multiply. I have a table and I want to add a column in the table of the data(in terms of visualizations) to have prices of 2019.
I need a visualization with all the information in the table data and add the following columns:
Group | Buyer 2019 | Sale 2019 |
So it seems like your data is set up in an almost completely useless way for PowerBI. Your best use of time is likely to normalize your data and set up unique indexes.
I'm guessing the intention is that Date in the Price table is a "Price First Effective" date, which makes sense, but then Buyers would need a Date Purchased column to make use of it. You could filter your visual by where Year = 2019, which solves filtering out 2018 data. However, I'm completely in the dark how you would want to calculate values for Buyer 2019 for given Group. Wouldn't it always be the same as Sale 2019?
Could you share your .pbix file? What you're asking might make more sense if we can see what you're trying to accomplish.