Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I am facing a problem where the database I am importing contains a percentage value (average unsubscription rate for instance) and it is, let's say 1,5%
I am getting the value as 1,5
Converting that through "modeling" --> "percentage formatting" makes it: 150,0% (since 1,5 is 150 in percent).
I would like either for it to understand that it already is 1,5% and thus just add a %-sign at the end, OR I would like to move the decimal to: 0,015 and then add the percentage formatting.
The outcome should be that the 1,5 i have today is the actual percentage (that just lost it's %-sign)
Thanks a lot
Andreas
Solved! Go to Solution.
Hi Andreas,
Add another calculated column such as:
AUR = [Average Unsubscription Rate]/100
Put this into a percentage and you'll get the required result.
Hi @Ancar,
Have you tried the solution provided by JoHo_BI above? It should work in your scenario.
Regards
Hi there,
Yes, it worked perfect! Thanks!
//Andreas
Hi Andreas,
Add another calculated column such as:
AUR = [Average Unsubscription Rate]/100
Put this into a percentage and you'll get the required result.
Hi JoHo_BI,
Thank you for the reply and the solution - it worked perfect! Exactly what I needed! Thanks a lot for your help!
Kind regards,
Andreas