I have a table with sales by agent and season like this:
I try to obtain a power bi matrix as:
Can i have an help, please?
i have a filter, where the user can choose the season and with a lookvalue function i find the last season.
So i writed two measure to calculate the quantity like this:
The problem is that in the "last season" colum, the value are present only when there is a value in a "quantity season" colum.
I like use the measure to obtain the goal, it's possible?