Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Diligent_
Frequent Visitor

How to return column of a table variable using DAX formula

itemitemsalessalesConsider 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? 

4 REPLIES 4
Nathaniel_C
Community Champion
Community Champion

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





Did I answer your question? Mark my post as a solution!

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.

Nathaniel_C
Community Champion
Community Champion

Hi @Diligent_ 

 

Would you provide us with a picture of expected output?

 

Thanks,

Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




This is the result I want to obtainThis is the result I want to obtain

I am trying to create a new column in the table items with these values inserted. 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.