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
maybe you know, how to write formula, then my data is in table for example:
a result I get Sales 2022 using a different formula %CT Sales 2022 this this column comes from SALES 2022
how do I get the measure so I can use it for other calculations?