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,
I'm trying to extract the number before the colon (see example below) using DAX.
Here are the steps I did:
1. To return the specified number of characters I want (it worked)
c_Search Request Target Time = SEARCH(":", 'MyRequest_Consolidated'[Request Target Time],,LEN('MyRequest_Consolidated'[Request Target Time]))-1
2. To extract the number before the colon
Is there any other way to extract the number I need before the colon (:)? The data type of the column is "Text". Thank you!
Solved! Go to Solution.
Hi @rosemilo
please try
c_Request Target Time =
IF (
MyRequest_Consolidated[c_Search Request Target Time] > 0,
LEFT (
'MyRequest_Consolidated'[Request Target Time],
MyRequest_Consolidated[c_Search Request Target Time]
)
)
Hi @rosemilo
please try
c_Request Target Time =
IF (
MyRequest_Consolidated[c_Search Request Target Time] > 0,
LEFT (
'MyRequest_Consolidated'[Request Target Time],
MyRequest_Consolidated[c_Search Request Target Time]
)
)
Thank you! It worked! 😊
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 |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |