Forum Discussion
Column that returns prior year value
Hi All, I am trying to add a column in to my table model that returns Prior Year amounts. Please see attached. For some reason my current formula is not working. Does anyone know how to solve fo...
Hi Anonymous ,
you have to create a Measure.
Look at this.
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Remember, you compute the ratio of the sums, not the sum of the ratio.
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.