Forum Discussion
jbenson
Helper III
Helper IIICurrent month minus previous month
i am wanting to add a column to my table. i want to be able to subtract the current months forecast number minus the previous months forecast number. i have a month column also in the same table. i h...
Hey jbenson
Lets try something more simple. To do that, you need to have a calendar table (you can create one using DAX if you don't have one).
Relate the calendar table with your Grain Margin table. After that, create two measures and that's it. See images bellow:Best Regards,
Marcel
jbensonHelper III
Helper IIIi got it to work, thank you for your help!
- marcelsmaglhaes
Super User
Hey jbenson !
Nice!!!! If this posts helps, please mark as solved to help other in our community.
Best Regards,
Marcel