Forum

@riny you could do split by ") " - i.e. closing parenthesis and a space - and at the same time Quote Character None (instead of "). This allowed me to...

Hi Colin, Data type of your columns is Currency, so it has to be either 0 or null. If you want it to be "", you'd have to change data type to Text - a...

@philipt Getting this result in PQ always confused me. Thank you for explaining it so well in this post. I think I finally get it!

So, the secret lies in calculated column(s) and not in a measure. I did not even think about it and was not familiar with some of these formulas. ...

The very same thing was happening at my company and my instructions for my coworkers have been ignored, too. I finally had to add a note to the front ...

Works like a charm. Thank you so much for your help, Riny!

Kasey, something similar happened to me a couple of times. I could not figure out the reason behind it, but as a workaround, I: First right-click...

Mynda, This didn't work for me the way as intended, because some policies can have multiple claims and some of those claims can be open while other...

Thank you so much, Mynda. I'll work on my data following your example. Blanka

Hi Mynda, Thank you for your reply. I have many more fields in my data that I need to use for analysis. Construction was just an example. And th...

I found a solution - it's a take on "Clustered and Stacked Column and Bar Charts" found on Peltier Tech Blog. I followed the technique described there...