Forum Discussion
Help with Line and stack column chart
You could create a custom column that you would then use as a filter or as a filter for a measure, something like:
Column =
VAR __Max = MAXX(ALL('Table'),[No. of hours])
VAR __MaxWW = LOOKUPVALUE(ALL('Table'[WW]),'Table'[No. of hours],__Max)
RETURN
IF([WW]<__MaxWW,1,0)
Hi Greg,
thank you for your answer but It doesn't work :\
the "No. of hours" column is unnecessary, the chart i created is based on the "**bleep** hours" column which is created by measure. maybe this is the reason the code you wrote isn't working to me :\
what i want is to create new column/measure, based on that measure (on "**bleep** hours" column), and changing evey row that is the max value to zero, except to the first time.
is it possile to do it?
thanks again!
Hilarious "***bleep*** hours!!
One thing I do not understand, why is your cumulative total 7 when you have 2 hours one week and 7 another week?
hahaha oops! it should be 9 instead of 7! sorry about it