Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear all,
we have balance account number begin with all the number from 1 to 9.
how can i filtre only the numbers begin with 6 and 7?
In the table, i choosed the format as Text.
Thank you for the help,
b regards,
Ariane
Solved! Go to Solution.
Hello @Orange2045
Use the below Dax to create a column, You can user this as a filter.
Flag =
IF (
OR (
LEFT ( table[Bal_Account_No], 1 ) = "6",
LEFT ( table[Bal_Account_No], 1 ) = "7"
),
1,
0
)
Let me know if this helps!
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Hello @Orange2045
Use the below Dax to create a column, You can user this as a filter.
Flag =
IF (
OR (
LEFT ( table[Bal_Account_No], 1 ) = "6",
LEFT ( table[Bal_Account_No], 1 ) = "7"
),
1,
0
)
Let me know if this helps!
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |