Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I've got an issue that I do now know how to solve in power BI. My dataset either lacks values (has 0's) in speciffic months or misses that speciffic month alltogether. My goal would be to model it the way I did in excel on the screenshots. I assume duplicating those rows exactly as they are is not too hard, by then it also has to go with half the value for the missing month and half to the one im copying from.
Ideally I need both of those 'cases' solved somehow using dax, but not at the same time (I will know which month will have 0's, and which different month will be missing at all).
Thank you for help in advance
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |