I am working on a data set where I need to find the percentage change from 2019 to 2020. My data is structured as follows:
I have tried the following and cannot get past the count/filter expressions. Any tips are apprecatied.
FY20Cases = CALCULATE( COUNTROWS(Table), FILTER(Table,Table[Opened Fiscal Year="2020"), FY19Cases = CALCULATE( COUNTROWS(Table), FILTER(Table,Table[Opened Fiscal Year="2019"), DIFF=[FY20 CASES]-[FY19CASES]
Go to Solution.
Proud to be a Super User!
View solution in original post
@vanessafvg I receive errors on the formulas. I am not getting anything in return. I have tried to rework the formulas and tried new expressions but I only receive errors.
Ive rerun your code and it works for me, see attached.
check your data types that might be an issue
also what error messages are you getting can you get a screenshot.
see the attached power bi file
UPDATE! I have figured out the issue - I have duplicate rows for a reason that is why the numbers are higher. Any idea on how to work around that?
I re-ran the code and it works. But the outputs are not correct. By using a pivot table I can see what the total cases were for FY19 and FY20. I will check my data types. See image below.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.