Hi Power BI Ninjas,
I'm fairly new to this but have worked with Excel for a long time so I have some transportable knowledge but some not.
So here goes.
My problem: I have test results that come in as either 'positive' or 'negative' into a column each day as tests are recorded.
And I want to show the percentage increase/decrease in the positive results based on my filtered date view.
So the way I see it there are two "formulas" needed here; the first would calculate the number of positive results as a percentage of the total tests taken on a specific day that is selected from a day filter.
And the second would compare that percentage to the previous day's percentage result and show whether there has been an increase or decrease.
Once I understand the string I'm sure I will be able to figure out how to build this out further into "this week vs last week/month/year etc". But my Excel formula skills are failing me right now in getting even the first part to work in Power BI let alone get the whole thing working.
Anyone who can help will be showered with vast quantities of praise and a significant amount of unnecessary emoji faces in thanks.
Just trying to say there's something in it for both of us hahaha. ฅʕ•̫͡•ʔฅ
Thanks in advance Ninja's
