Forum Discussion

sy898661's avatar
sy898661
Icon for Helper V rankHelper V
7 years ago
Solved

Return a value in a column

Hi!   I'm sorry in advance if this is a dumb question but I was wondering if someone could help with my syntax:   Generation Duration 2 = IF('board-Query'[Generation Duration] = 43658, "", 'board...
Need Help
  • Cmcmahan's avatar
    Cmcmahan
    7 years ago

    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])
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

Cmcmahan's avatar
Cmcmahan
Icon for Resident Rockstar rankResident Rockstar
7 years ago

I would use this for your average:

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.