Forum Discussion
Scaling Numbers within Power BI
Hello Power BI Community, I am working on a project that requires scaling of data within Power BI. Attached is an example file with a small dataset. The dataset I am using is much larger and more...
Hi phodges ,
You could update the pbix to onedrive and share the link here.For switch() function you could try below formula.
Switch(true(),condition1,result1,condition2,result2,etc...)
Best Regards,
Jay
Thank you for your reply. Yes I have tried the switch function, but because I have 20 possible conditions it takes a very long time. It seems, by all that I have been reading, this is the proper way to do, but it is far too slow. I will keep working on it and if I find a solution I will post in case someone else needs a similar solution. If you, or anyone, has any other ideas I would love to hear them. Thanks again for your help!