COLUMNS

The COLUMNS identifier returns a reference to a specific column in the report. Type 'COLUMNS.' to enable a dropdown with a list of all the columns available in the visual.

Columns reference

'Columns' is applicable only when inserting visual measures.

Example#

We have a discount value for all months. If we want the discount value of January month to be applied for all months, then it can be achieved using the columns function as shown below.

Columns reference

Enterprise planning, Integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co Engineered with Lumel.
BUILT ON