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.
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.
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 |
---|---|
51 | |
27 | |
24 | |
13 | |
8 |
User | Count |
---|---|
74 | |
56 | |
47 | |
16 | |
12 |