Forum Discussion
Formula
how to calculate and get percentages in a column?
Sales =
VAR _total =
Calculate(
SUM('Planam'[Sales 2022]),
Filter('Planam','Planam'[month] = Earlier('Planam'[month]))
)
RETURN _total
try this out
2Sale2s =
VAR _total = sum('Planam'[Sales])
var _val = 'Planam'[Sales]
return
_val/_total
should also be added here
can you write how to have be?
Try this out
2Sale2s =
VAR _total =Calculate(
SUM('Planam'[Sales]),
Filter('Planam','Planam'[month] = Earlier('Planam'[month])))
var _val = 'Planam'[Sales]
return
_val/_total