Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 Matches)
That is Team Name = Win Win Lost Win Lost
Latest Form =
var team = SELECTCOLUMNS(matches,"Team1",matches[winner])
var temp = FILTER(SUMMARIZE(matches,
matches[winner],
matches[date],
"form", IF(COUNT(matches[winner])>0,"W","L")),
(CALCULATE(COUNTROWS(ALLSELECTED(matches)),FILTER(ALLSELECTED(matches),matches[team1]=team)) +
CALCULATE(COUNTROWS(ALLSELECTED(matches)),FILTER(ALLSELECTED(matches),matches[team2]=team))
) >=1 )
return MAXX(TOPN(5,temp,[date],DESC),[form])
This calculated measure is giving an error. I even tried creating Table but still getting the same error. Kindly suggest possible solution.
@Zubair_Muhammad - Tagging you explicitely as you know the dataset and also cricket very well 🙂
Solved! Go to Solution.
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 )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |