Replicate a filter in power bill to the one which was there in Cognos FM

[RavikanthV]

Hi, 

I am trying to replicate a filter in cognos FM to power bi. The cognos FM formula for "max c exp dt" Is CD. CD exp date = CD. Max CD exp date

Can someone help with this, like how I need to replicate the above cognos filter in power bi. 

[Anonymous · Accepted solution]

Hi  @RavikanthV ,

Do you want to get the maximum date in the filter:

Select the Date column in Filters .

Filter type：Top N

Show items ： Top  1

By Value： Lastest Date.

If the above results do not meet your expectations, you can express your expected results in the form of pictures and provide sample data that does not contain sensitive data, we can better help you.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[RavikanthV]

Hi Chirag, 

Thanks for the reply and suggestion. 

May be, I have not framed my question properly. 

I am looking to replicate the said filter on the filter pane. 

Thanks, 

Ravikanth

[ChiragGarg2512]

Try This:

CD. CD exp date =
VAR MaxCDExpDate = MAX(CD[Max CD exp date])
RETURN IF(CD[CD exp date] = MaxCDExpDate, TRUE(), FALSE())

If this doesn't work, please share the sample data.