Forum Discussion
Augustas-ase
Helper II
Helper IIFormula
how to calculate and get percentages in a column?
Augustas-aseHelper II
Helper IIor how can i multiply this? sales 2022 x %ct sales 2022
BIswajit_Das
Impactful Individual
Impactful IndividualFor any calculations you need to use calculated columns or measure
- Augustas-ase
how to calculate measure? then for example, Sales 2022 value: cow is 544,385, and how to measure i can get percentage 43,06?
- BIswajit_Das
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- BIswajit_Das
You can also use the same DAX in order to create a measure