Reply
Frequent Visitor
Posts: 10
Registered: ‎11-10-2017
Accepted Solution

Dynamicaly Filtered Calculated Table

 

Hello, I have a visualization that looks like this:


Table1.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

And I would need to create  MEASURE called Latest LAPSED Status Date that returns, for each row, the latest date where each Partner had the status of Lapsed.  The result should be a table like this:

 

Table2.JPG

 

 

 

 

 

 

 

 

 

 

 

Could anybody help me withe the DAX Code ?  I would really appreciate it !  

Thanks a lot in advance,

 

Joaquin


Accepted Solutions
Community Support Team
Posts: 7,467
Registered: ‎08-14-2016

Re: Dynamicaly Filtered Calculated Table

Hi @johmedrano,


You can try to use below formula to find out last update date of each partner:

Last Update =
CALCULATE (
    MAX (
        Table[Date],
        FILTER (
            ALLSELECTED ( Table ),
            Table[Partner Name] = SELECTEDVALUE ( Table[Partner Name] )
        )
    )
)

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

Highlighted
Frequent Visitor
Posts: 10
Registered: ‎11-10-2017

Re: Dynamicaly Filtered Calculated Table


All Replies
Community Support Team
Posts: 7,467
Registered: ‎08-14-2016

Re: Dynamicaly Filtered Calculated Table

Hi @johmedrano,


You can try to use below formula to find out last update date of each partner:

Last Update =
CALCULATE (
    MAX (
        Table[Date],
        FILTER (
            ALLSELECTED ( Table ),
            Table[Partner Name] = SELECTEDVALUE ( Table[Partner Name] )
        )
    )
)

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Highlighted
Frequent Visitor
Posts: 10
Registered: ‎11-10-2017

Re: Dynamicaly Filtered Calculated Table

Thanks !