Forum Discussion

CMajka8's avatar
CMajka8
Icon for Helper II rankHelper II
3 years ago

Format columns using DAX

Hello -  Is it possible to format the columns inside this table expression using DAX? For example, "CTR" should show as a % with 2 decimal places and "CPC" should show as a dollar am ount with 2 dec...
ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
3 years ago

What format do you want to see?

CMajka8's avatar
CMajka8
Icon for Helper II rankHelper II
3 years ago

For Cost metric, I would like to display as a whole number [thousands]. For example, instead of showing as $0.39M, I would like to show $390,000. And for the CTR metric, I would like to show as % with 1 decimal. Thanks