Forum Discussion
Divide Measures
Hello dear PowerBI community, I do need your help regarding a calculation i want to do with 2 created measures: I do have 2 measures: TO2016 cumul. and TO2017 cumul. These 2 ...
Hi Paddhof1984,
It will be help if you share some sample data and the measure formulas.
In addition, if your measure contains some specific filters or 'all' filter, they may not works in other measures.
Regards,
Xiaoxin Sheng
Hello,
my measures:
TO2016 cumul.:
TO2016 cumul. = TOTALYTD(SUM(RE2016[TO2016])|'Calendar'[Date])
TO2017 cumul.:
TO2017 cumul. = TOTALYTD(SUM(RE2017act[TO2017act])|FILTER(ALL('Calendar'[Date])|'Calendar'[Date]<=MAX(RE2017act[PurchDate])))
sample Data: