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.
Hi all
The provided Power BI data model includes 'Date' and 'Stores' as dimension tables and 'Managers' as a fact table, linked by a one-to-many relationship.
Can you help me to create a calculated column in the 'Stores' table to display the latest manager entry from the 'Managers' table, as depicted in the illustration.
Thanks in advance
regards
Solved! Go to Solution.
Hi @Anonymous ,
Here are the steps you can follow:
1. Create calculated column.
Mg =
var _date=
MAXX(
FILTER(ALL('Managers'),
'Managers'[Stores]=EARLIER('Stores'[Stores])),[Date])
return
MAXX(
FILTER(ALL('Managers'),
'Managers'[Stores]=EARLIER('Stores'[Stores])&&'Managers'[Date]=_date),'Managers'[Manager])
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@Anonymous
is this what you want?
Proud to be a Super User!
Hi @Anonymous ,
Here are the steps you can follow:
1. Create calculated column.
Mg =
var _date=
MAXX(
FILTER(ALL('Managers'),
'Managers'[Stores]=EARLIER('Stores'[Stores])),[Date])
return
MAXX(
FILTER(ALL('Managers'),
'Managers'[Stores]=EARLIER('Stores'[Stores])&&'Managers'[Date]=_date),'Managers'[Manager])
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |