Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi
I have this forumla to trim the data but I have one item which I still need to remove '-U'.
How can I include that in the same formula let's say to trim also the data where '-U' is identified.
Only measure please because I cannot import all tables in Power BI and use custom columns and power query.
Solved! Go to Solution.
Hi @adoalan
Change the RETURN statement to this
RETURN SUBSTITUTE(MID(EvalString, 1, LenTo), "-U", "")
Regards
Phil
Proud to be a Super User!
Hi @adoalan
The 2nd image shows that you have many different Codes in your table, so when you are only seeing 1 row when the Final 1 measure isn't included, this may be because of some other filtering or aggregation on that visual.
The measure isn't duplicating data, that data is there, it's just not shown in your first visual.
Regards
Phil
Proud to be a Super User!
Actually there is an error. Instead of getting one line like below
I get this
When I remove the formula
Is giving the correct results.
Any idea how to fix this issue?
Thanks
Hi @adoalan
Sorry I'm not seeing what the problem is. What do you want as the result?
regards
Phil
Proud to be a Super User!
The result should be just one line in the example which I posted below But somehow the formula is duplicating some values.
For example if I put a filter on ADDC06-01/002-UK
On the report without formula added I get only one line eith the amount of 63.
But when I drag the formula in I see all those with different Codes, the same sourcecode and the same amount
Let me know if makes sense
Thank you
Hi @adoalan
The 2nd image shows that you have many different Codes in your table, so when you are only seeing 1 row when the Final 1 measure isn't included, this may be because of some other filtering or aggregation on that visual.
The measure isn't duplicating data, that data is there, it's just not shown in your first visual.
Regards
Phil
Proud to be a Super User!
Hi @adoalan
Change the RETURN statement to this
RETURN SUBSTITUTE(MID(EvalString, 1, LenTo), "-U", "")
Regards
Phil
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
85 | |
66 | |
52 | |
47 |
User | Count |
---|---|
215 | |
90 | |
83 | |
66 | |
58 |