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.
Hello - My measure below returns results as expected until the underlined part. I need to add more filtering with dates that I can't seem to do. I want to be able to say X date (related table) is less than Y date. Thoughts? Thanks!
Hi @Anonymous ,
Please try this one.
Measure 2 =
VAR d =
MAX ( Opportunity[CreatedOn] )
RETURN
CALCULATE (
COUNT ( Opportunity[OpportunityId] ),
FILTER (
altus_leadstage,
altus_leadstage[altus_name] = "MQL"
&& altus_leadstage[altus_Date] < d
),
USERELATIONSHIP ( Opportunity[ParentContactId], altus_leadstage[altus_Contact] )
)
Hi @Anonymous ,
Please make your data type of your date columns to be the same and check again.
Hi @Anonymous ,
Has your issue been solved? If so kindly mark my answer as a solution to close the case. Thanks in advance. Any other question, feel free to let me know please.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
You should be use like
Table1[Date] = related(Table2[Date])
Or
Table1[Date] =Max(Table2[Date])
Please provide the complete clause for more help.
Can you share sample data and sample output.
Appreciate your Kudos.
Thanks for the response and sorry for my delayed response. Still getting an error...
Hi,
Try this measure
Measure 2 = CALCULATE(COUNT(Opportunity[OpportunityId]),USERELATIONSHIP(Opportunity[ParentContactId],altus_leadstage[altus_Contact]),FILTER(altus_leadstage,altus_leadstage[altus_name]="MQL"&&altus_leadstage[altus_Date]<MAX(Opportunity[CreatedOn])))
If it does not help, then share the link from where i can download your PBI file. Clearly show the problematic measure there.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |