Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a measure that is working just fine:
ProfType =
var _max = MAXX( FILTER( ProfessionalType, ProfessionalType[EffDate] <= MAX( Dates[Date] ) ), ProfessionalType[EffDate] )
return
Calculate(
max( ProfessionalType[ProfessionalType] ),
Filter( ProfessionalType,
ProfessionalType[EffDate] = _max
)
)
The problem is that it returns a result for every Professional, even if they have no other data for a time period. So I think it would be better if this measure was a calculated column in the table instead, but I can't figure out the syntax to make that happen. Help!
Solved! Go to Solution.
Hi,
I am not sure how your datamodel looks like, but please try the below for creating a new column whether it suits your requirement.
ProfType calculated column =
VAR _max =
MAXX (
FILTER (
ProfessionalType,
ProfessionalType[EffDate] <= EARLIER ( ProfessionalType[EffDate] )
&& ProfessionalType[ProfessionalType]
= EARLIER ( ProfessionalType[ProfessionalType] )
),
ProfessionalType[EffDate]
)
RETURN
MAXX (
FILTER (
ProfessionalType,
ProfessionalType[EffDate] = _max
&& ProfessionalType[ProfessionalType]
= EARLIER ( ProfessionalType[ProfessionalType] )
),
ProfessionalType[ProfessionalType]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure how your datamodel looks like, but please try the below for creating a new column whether it suits your requirement.
ProfType calculated column =
VAR _max =
MAXX (
FILTER (
ProfessionalType,
ProfessionalType[EffDate] <= EARLIER ( ProfessionalType[EffDate] )
&& ProfessionalType[ProfessionalType]
= EARLIER ( ProfessionalType[ProfessionalType] )
),
ProfessionalType[EffDate]
)
RETURN
MAXX (
FILTER (
ProfessionalType,
ProfessionalType[EffDate] = _max
&& ProfessionalType[ProfessionalType]
= EARLIER ( ProfessionalType[ProfessionalType] )
),
ProfessionalType[ProfessionalType]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
47 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
56 | |
28 | |
20 | |
16 |