Create query that gives a "temporary" table, similar to MS Access?

[mbrown1]

I'm super new to PowerBI so forgive for my lack of knowledge. In MS Access I have a database with an important query I need. I'm planning on recreating that query in MS Access. It should just be a simple query that returns a table with the different Lookup columns and such? All youtube videos I watch seem way more in-depth than I need.

[amitchandak · Accepted solution]

@mbrown1 , You can create a table in a variable. It can be done in column, measure or table formula

New column

Var _tab = calculatetable(sales, sales[item id] =1)

New Measure =

Var _tab = summarize(allselected(Item), Item[Name])

[mbrown1]

Would I need to create a button that activates all the columns? I don't know much about PowerBI, I come from PowerApps