Forum Discussion
Division error - fields does not appear
Hi, I have error with division in dax formula. When using new measure : There is no numerator or denominator link to the fields. When using quick measure, I could divide but is don...
Anonymous
You need to add an function to refer to a value when creating a measure. In your case, using sum, max, min or any other function does not change the result. And to get the current year margin%, you can create a measure with filter to today()'s year:Current Year Margin% = Calculate( [Margin%], Filter(Table, [Date].[Year]= Year(Today()))
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Anonymous
What is your formula looks like? Or you can use following instead.
Last Year Margin% = Calculate( [Margin%], Filter(Table, [Date].[Year]= Year(Today())-1))
Paul