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.
Dear BI pros,
I hope you can help me with the following:
I am trying to count the processing steps that were performed on time for any given period.
But for some reason I am having problems with the DAX function:
@Smeek - If this is a measure, you need to wrap column references in an aggregator so maybe try. @ me in replies
on time = CALCULATE(DISTINCTCOUNT(Processing Steps[Processing Steps No]),
Processing Steps[Processing Steps Status]="Finished",
USERELATIONSHIP(Processing Steps[Target Enddate],Date[Date]),
MAX(Processing Steps[Actual Enddate])<=MAX(Processing Steps[Target Enddate])))
If not, not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, 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
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Hi Greg,
thanks for your answer.
Yes, it is a measure I am trying to calculate.
I tried wrapping the date comparision with MAX, MIN, Filter...but it doesn't work. The message: Only a column reference is accepted as argument by the function 'MAX'.
Both date columns are formated as dates, although the 'Actual Enddate' is a calculated column pulling the dates from another table via RELATED.
I will try and see if I can setup a sample database.
Thanks
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |