Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

% and number values in single column

how do make matrix for the following measures in a column

 

Revenue         - 123123

Gross Profit    -   24624.60

Gross Margin  - 20%

Net Profit       - 9234.225

Net Margin - 7.5%

 

 

Need Help

2 Replies

  • Endiii's avatar
    Endiii
    Frequent Visitor
    3 years ago

    The question is what design you would like to get. 
    If simple one where values are displayed as rows like:

     

    Then your formula would be:

    Gross Profit & Margin = 'Table'[Gross Profit] & "  " & FORMAT('Table'[Gross Margin],"Percent")

    and 

    Net Profit & Margin = 'Table'[Net Profit] & "  " & FORMAT('Table'[Net Margin],"Percent")

     

    If you want to achiev something else, please provide more details

  • mmanicakvasagam's avatar
    mmanicakvasagam
    New Member
    3 years ago

     

    Error came 

     i used following Dax, please check and advice 
     
    Amt =
    SWITCH(
        TRUE(),
        MLayout[name] = "Revenue", [Revenue],
        MLayout[name] = "Gros Profit", [GP],
        MLayout[name] = "Gros Margin", [GP Margin]
    )