Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi girls & guys,
I have 2 very simple tables:
1.) Sales
2.) Product Table
Now as you can see within the Product table, there's one item, "2536" or "TV Remoate", that comes at different pricing options, depending on the quantity customers purchase it at.
Since there are no unique values, I'm staying away from building a relationship within the model itself. I would much rather create a separate, calculated column within the Sales table, listing the price according to quantity ordered.
Now I would presume, that the easiest way would be a Lookupvalue function creating the column. But I'm having trouble entering it so it aggregates properly.
Could anyone kindly help me out or suggest if there's an easier option to do this?
Thanks in advance!
Solved! Go to Solution.
Hi,
I suggest creating Product table like below.
And then, Range of MIn column and Max column can be used like below.
Please check the attached pbix file. All Calculated Columns are in the attached pbix file.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi there!
may I pick up this problem from before and inquire about one more piece of coding to what has worked as a charm so far?
My Product table now has 2 additional columns with a mix of current and historic prices that have changed due to price increases. I would now need the code to not only aggregate by quantity amount but also by which time window the sales price has been valid for if that makes sense?
Thanks guys!
Did the trick, beautifully! Thank you kindly!!
Hi,
I suggest creating Product table like below.
And then, Range of MIn column and Max column can be used like below.
Please check the attached pbix file. All Calculated Columns are in the attached pbix file.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |