Search code examples
powerbidaxpowerbi-desktop

combine 2 numeric cells in Dax


How to combine 2 columns using DAX.

Expected Format 71,937,178 (8.09%)

G/L Weekly Revenue and Its PCT = ROUND( 'Calculations'[Weekly Sales], 2 ) & " ( " &  
                                     [Revenue | G/L PCT] & " )"

enter image description here


Solution

  • G/L Weekly Revenue and Its PCT = ROUND( 'Calculations'[Weekly Sales], 0 ) & " ( " &  
                                         FORMAT([Revenue | G/L PCT], "0.00%") & " )"