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.
I am trying to figure out the best way to go about trimming a column, but only when it meets a certain criteria. And leave the Urls as they are that don't meet the criteria.
I want to rollup all the Urls that contain '/dispatch/calendar/daily/xxxx-xx-xx' into one row in the Report view '/dispatch/calendar/daily/' to get a better sense of how often the daily calendar is used and not the individual days
Solved! Go to Solution.
Create this calculated column and use it in your visual (use your table name instead of Table1):
sUrl Trimmed =
IF (
CONTAINSSTRING ( Table1[sUrl], "/dispatch/calendar/daily/" ),
"/dispatch/calendar/daily/",
Table1[sUrl]
)
Proud to be a Super User!
Glad to hear that works. I recommend the SWITCH function for nesting:
sUrl Trimmed =
SWITCH (
TRUE,
CONTAINSSTRING ( Table1[sUrl], "/dispatch/calendar/daily/" ), "/dispatch/calendar/daily/",
CONTAINSSTRING ( Table1[sUrl], "/marketing/keyword/" ), "enter text here",
Table1[sUrl]
)
Proud to be a Super User!
Create this calculated column and use it in your visual (use your table name instead of Table1):
sUrl Trimmed =
IF (
CONTAINSSTRING ( Table1[sUrl], "/dispatch/calendar/daily/" ),
"/dispatch/calendar/daily/",
Table1[sUrl]
)
Proud to be a Super User!
Absolutely wonderful ty so much.... works like a charm.... Also one follow up, I assume it would work if I used it in a nested query too.. if I had other url's that needed a trim like say "marketing/keyword/"
Glad to hear that works. I recommend the SWITCH function for nesting:
sUrl Trimmed =
SWITCH (
TRUE,
CONTAINSSTRING ( Table1[sUrl], "/dispatch/calendar/daily/" ), "/dispatch/calendar/daily/",
CONTAINSSTRING ( Table1[sUrl], "/marketing/keyword/" ), "enter text here",
Table1[sUrl]
)
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 |
---|---|
143 | |
78 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
61 | |
60 |