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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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