Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
I am using three columns of data:
I am looking for a New Measure formula to help me find the variance in 'Phys Cases' 2018 vs 2019 and by month.
Any ideas? Thank you for your help.
Solved! Go to Solution.
First create a new table calendar (if not already done one).
Then try this for the actual number difference:
I have seen on many boards that creating a new table calendar is the suggested route to take, however with limited Power BI knowledge, I had trouble creating a new table calendar in time to meet my deadline. I was able to create the following workaround:
(1) Create three new meaures to filter Physical Cases by Year:
(2) Find Physical Case Variance between each year
I have seen on many boards that creating a new table calendar is the suggested route to take, however with limited Power BI knowledge, I had trouble creating a new table calendar in time to meet my deadline. I was able to create the following workaround:
(1) Create three new meaures to filter Physical Cases by Year:
(2) Find Physical Case Variance between each year
First create a new table calendar (if not already done one).
Then try this for the actual number difference:
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |