Forum Discussion

dofrancis3's avatar
dofrancis3
Resolver I
2 years ago

Display last dates values

Hello Colleagues!

Please i need your help about the following:

I have already a mesure witch contain my pourcentage (in the first column) so, i would like a mesure who will display only pourcentage of last date highlight in yellow in the printscreen below:

Note: I don’t need to calculate pourcentage but just display.

 

 

Thank for your support.

7 Replies

  • Daoud_H's avatar
    Daoud_H
    Helper I
    2 years ago

    Hi dofrancis3,

     

    Maybe this will do the trick, try to create a column : 

    LastDatePercentage = 
VAR LatestDate = MAX('YourTableName'[Start date])
RETURN
CALCULATE(
    MAX('YourTableName'[LQAS]),
    FILTER(
        'YourTableName',
        'YourTableName'[Start date] = LatestDate
    )
)

     

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    hi, dofrancis3 

     

    not sure but try below code for measure

    latest_date=
 maxx(
          filter(
            all(table[country],table[stratdate]),
            table[country]=max(table[country])
          ),
          table[startdate]
 )

     

    now make table visual and drag your country column and percantage measure and  above latest_date measure

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    hi, dofrancis3 

     

    try below measure

     

    latest_date=
calculate( 
    [your measure],
    max(table[startdate],
    allexcept(table,table[table[country]])
)

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, dofrancis3 

    Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

    Best Regards

    Yongkang Hua