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.
Consider the following problem: we have two tables: item and sales. Id is a primary key. Suppose we sell last item with some discount (we know nothing about this discount).
We want to add the column with the price of the last sold item to the table item.
We are using something like this:
Last_price=
Var
table_variable=FILTER(RELATEDTABLE(Sales);Sales[discount]=1)
Return
table_variable[price]
It is not working. But is there a way to return the column using column of the table variable?
HI @Diligent_
Does the discount signify it is the last item? If not how do you know it is the last item?
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
We have a discount only if the last item left. In case of item fancy shoes we have a 50 % discount ( it could be 40% or 60% we have no information on the value of the discount)
The example stated is Just a problem to illistrate the question of how to reffer to the column of a table variable.
Hi @Diligent_
Would you provide us with a picture of expected output?
Thanks,
Nathaniel
Proud to be a Super User!
I am trying to create a new column in the table items with these values inserted.
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |