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.
Solved! Go to Solution.
You haven't closed the ALL statement; FILTER(ALL('Bearbeiten - FA-Arbeitsgang'[Status]),
Br,
Johannes
I need to change the very last part of this statement to exclude if the date is 1/1/2099.
This is my very first time asking a question, so if I'm not following the proper steps please let me know.
Hi @Anonymous,
Just to make sure i'm on the right track. You dont want to count employees with termination date 2099/1/1?
Br,
J
That is correct. I'm sure its a simple matter of syntax, but again I am learning and hoping to learn more in this forum. Thanks
Try something along the lines of this:
Current Staff =
CALCULATE( COUNTROWS( 'HRData' ),
FILTER( VALUES( 'HRData'[Hire_Date] ), 'HRData'[Hire_Date] <= max('Calendar'[Date] ) ),
FILTER( VALUES( 'HRData'[Termination_Date] ),
AND(
'HRData'[Termination_Date] <> DATE(2099,1,1),
OR(
'HRData'[Termination_Date] >= MIN('Calendar'[Date] ),
ISBLANK( 'HRData'[Termination_Date] )
)
) ) )
You haven't closed the ALL statement; FILTER(ALL('Bearbeiten - FA-Arbeitsgang'[Status]),
Br,
Johannes
I am also having smilar issue.
can someone please advise?
hi , @forgetmenot
filter need table argument as a first expression which you not mention you only mention filter expression
Average New = CALCULATE(AVERAGE('Current & Prior Forecast Combined'[FYE FINAL]), Filter(Current & Prior Forecast Combined','Current & Prior Forecast Combined'[CL Type]="New"))
Thank you 🙂
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |