Forum Discussion
Formula
how to calculate and get percentages in a column?
You got a column sales 2022 with value 544,385
Then you have a create an other calculated column for to get 43.06%
Formula for the column is :-
#column =
VAR _total = SUM([Sales 2022])
VAR _val = [Sales 2022]
RETURN
ROUND((_val / _total)*100,2)
then later you can use the #column For other calculations
You can also use the same DAX in order to create a measure