Forum Discussion

ajinkya1907's avatar
ajinkya1907
Icon for Helper II rankHelper II
8 years ago
Solved

Display the list

Dear Friends,   I am using IPL Crikcet Data set which can be found on https://drive.google.com/open?id=1DOyDC2V1XE7BUAMNzQeT9HzfuIYDEQ5f   I would like to calculate Team's latest form (Latest 5 ...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi ajinkya1907

 

Try this MEASURE. then Put it in a TABLE VISUAL with TEAM 1

 

Measure =
CONCATENATEX (
    TOPN ( 5, matches, [date], DESC ),
    IF (
        CALCULATE ( VALUES ( matches[winner] ) ) = SELECTEDVALUE ( matches[team1] ),
        "Won",
        "Lost"
    ),
    " ",
    [date], DESC
)