DAX - support - return final number of days

[TornDigorn]

Hello dear PBI community

I need help in creating a DAX expression that will allow me to return the value "number of days" in the column "return final number of days" but only in the row where the date appears in the "final date" column,  other rows should be blank. 

Expected result below -  (Expected returned value in green)

[TornDigorn]

@NaveenGandhi  Hello Again, 

it works, but not as it should 

4 (number of days)  should be returned just next to the final date 

Thanks for your patience 😉

[NaveenGandhi · Accepted solution]

@TornDigorn 

Please remove the Max function that is highlighted below.

Let me know if this helps and if you have any question.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

[TornDigorn]

Hello @NaveenGandhi 

Got it ! Thanks a lot ! 🙂

[NaveenGandhi]

Hello @TornDigorn 

Try the below DAX.

Final Days =
VAR Max_date =
CALCULATE ( MAX ( 'Table'[Date] ), ALLEXCEPT ( 'Table', 'Table'[Name] ) )
RETURN
IF (
'Table'[Date] = Max_date,
CALCULATE (
MAX ( 'Table'[Number of Days] ),
ALLEXCEPT ( 'Table', 'Table'[Name] )
),

BLANK()

)

Let me know if this helps and if you have any question.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

[TornDigorn]

Hello NaveenGandhi

unfortunately there is a bug

[NaveenGandhi]

@TornDigorn 

Just replace the "" with BLANK(), I have made the edit to my orginal DAX as well. It should work now.

I created it as a measure, for a column you need to make this change.

Thanks,

Naveen