Hi Guys just wondering why i cant reference the column i made in my variable, i am trying create a measure that basically computes the difference between the date values so i need to find a way of getting the groupedtable values for different dates.
The problem is when i try to reference the new value column i created which is the sum of values grouped by dates, it doesnt allow me to reference??
Can anyone figure out why or how i should approach this problem ?
@AlB i tried, but it ends up giving me the total values of all the months combined when i try to use the measure in a table split by the months column, because of this i can't choose a particular month and use its value in calculations.