Forum Discussion
Solved
Create new table based on calculated functions.
I have some quick measurements and want to make a temporary table like this one: Fullname is a selected field based on filters, the bodycomps are calculated fields. How can I make a temporary ...
Hi DionTN ,
Are you instead referring to calculated table? There are more than one ways to do this in Power BI. An example where existing measures are used:
calctable = ADDCOLUMNS ( SUMMARIZE ( FILTER ( 'table', 'table'[column] = "criteria" ), 'table'[column] ), "Measure 1", [Measure 1], "Measure 2", [Measure 2] )
Hi DionTN ,
Are you instead referring to calculated table? There are more than one ways to do this in Power BI. An example where existing measures are used:
calctable =
ADDCOLUMNS (
SUMMARIZE ( FILTER ( 'table', 'table'[column] = "criteria" ), 'table'[column] ),
"Measure 1", [Measure 1],
"Measure 2", [Measure 2]
)
You can use VAR but depending on how you use it, it may or may not result your desired result. See samples below: