Forum Discussion
Generating new column based on another column values
click on Modeling->New Table then the DAX to create the new table is the following:
newTableName = filter(all(oldTableName), oldTableName[Annual Spend (USD)]>0)
Chitemerere . In visual level table you can have visual level filter <> 0
in Power Query you can filter <> 0 or copy table and filter <>0
in dax you can create a new table
https://docs.microsoft.com/en-us/dax/calculatetable-function-dax
cnew Table = alculatetable(Table, Table[Annual Spend (USD)] <>0 )
Chitemerere . In visual level table you can have visual level filter <> 0
in Power Query you can filter <> 0 or copy table and filter <>0
in dax you can create a new table
https://docs.microsoft.com/en-us/dax/calculatetable-function-dax
cnew Table = alculatetable(Table, Table[Annual Spend (USD)] <>0 )