Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
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
hi, @dofrancis3
try below measure
latest_date=
calculate(
[your measure],
max(table[startdate],
allexcept(table,table[table[country]])
)
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
It doen't work unfortnatly
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
)
)
Hello Guy!
Please support...
User | Count |
---|---|
57 | |
46 | |
19 | |
16 | |
15 |
User | Count |
---|---|
116 | |
41 | |
40 | |
28 | |
22 |