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 community!
I'm really new in Power BI and ran into an issue that I can't figure out. I need to add month values to the column next to the QTY to be able to see qty of certain month. The data is coming from Sharepoint list where one of the columns is "Month".
I was thinking if it was maybe possible to populate value of month name into next 8 cells somehow, because 8 cells is always a constant? So that there is month name in one cell and next eight cells in the column have the same month name as well.
Thanks in advance!
Solved! Go to Solution.
Should be able to do this in a couple of steps - first I'd replace anything that says other with a null, and then you should be able to use Table.FillDown to get the result you want
Should be able to do this in a couple of steps - first I'd replace anything that says other with a null, and then you should be able to use Table.FillDown to get the result you want
I can't belive it was simple as that. Thanks!
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |