Forum Discussion
Helper VReturn a value in a column
I would use this for your average calculation:
AverageWithout43568s = CALCULATE(AVERAGE('board-Query'[Generation Duration]), 'board-Query'[Generation Duration] <> 43658)And replace the average with whatever calculation you want to do for other measures.
If you really need a calculated column that shows non-43568 values, you could edit your original formula for a calculated column:
Generation Duration 2 = IF('board-Query'[Generation Duration] = 43658, BLANK(), 'board-Query'[Generation Duration])You could also clean that up a bit more since IF defaults to null if you don't provide an alternate value:
Generation Duration 3 = IF('board-Query'[Generation Duration] <> 43658, 'board-Query'[Generation Duration])
hi sy898661
Please try using Conditional colum approach this way:
- hit on Edit queries
- Conditional Column
- Look at below screesnhot
- hit ok
-apply and close
I got this output
Thanks,
Tejaswi
Helper VAnonymous omg this would be so perfect BUT I just checked and unfortunately I do not have permission to edit the query :( do you know of any way via DAX?
Hi sy898661
Try this measure.
Measure = Maxx(Sheet2, if(Sheet2[Sasles]=43658,Blank(),Sheet2[Sasles]))My output:- sy898661
Hi Anonymous ,
Now it is just populating the entire column with 68-the max value that is not 43658, instead of copying over the data from the other column
what the heck is going on :( I am **bleep** near 100% positive I typed it the same way you did--I wonder why it worked for you but isnt working for me
Can you share the screenshot?