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.
I apologize - I must not have read your entire request -
Below I attempted to replicate the request you have asked for.
This was acomplished by utilizing the below IF statement -
Status =
IF(
AND(
ISBLANK(Sheet1[Release Date]),
ISBLANK(Sheet1[Hire Date])),
BLANK(),
IF(
ISBLANK( Sheet1[Release Date] ),
BLANK(),
IF(
ISBLANK( Sheet1[Hire Date] ),
"Error" )
))
Let me know if this works for you. If so throw me a thumbs up and mark as the solution.
Enjoy!
I hope im not incorrect. However -
With PowerBI a column must contain the same data type. Meaning - a field which contains dates, cannot also contain text. You're error message may need to be contained in a seperate field.
I would make a calculation so that if you're returning a blank row - a calculated column beside it could simple be:
ERROR =
IF(
ISBLANK( [THE OTHER COLUMN] ),
"ERROR MESSAGE",
"")
Create a filter to only show errors, and you have an error report of sorts.
Let me know if this helps!
If it works, let me know! Also - If it works throw this post a thumbs up, and deem it as the solution.
I apologize - I must not have read your entire request -
Below I attempted to replicate the request you have asked for.
This was acomplished by utilizing the below IF statement -
Status =
IF(
AND(
ISBLANK(Sheet1[Release Date]),
ISBLANK(Sheet1[Hire Date])),
BLANK(),
IF(
ISBLANK( Sheet1[Release Date] ),
BLANK(),
IF(
ISBLANK( Sheet1[Hire Date] ),
"Error" )
))
Let me know if this works for you. If so throw me a thumbs up and mark as the solution.
Enjoy!
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 |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |