Display column types in visual

[Anonymous]

Hi, 

is it possible to display the data types of columns in a visual?

Googling only gives me tips on data types....

Thanks

[Mariusz · Accepted solution]

Hi @Anonymous 

Please see below DAX expression that can test a few data types.

Measure = 
VAR _var = "text" -- TRUE(), "text", 123
RETURN 
SWITCH(
    TRUE(),
    ISLOGICAL( _var ), "True\False",
    ISTEXT( _var ), "Text",
    ISNUMBER( _var ), "Number" 
)

Unfortunately could not find any function to test date/time or if the number is whole, fixed or decimal.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.