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.
I'm trying to import an Excel spreadsheet but the data in the sheet has rows grouped by date. An example:
Item | Ship Date |
522 | Jan-20, 2018 |
747 | |
642 | |
834 | |
414 | Jan-21, 2018 |
996 | |
568 |
All the Items on and below the row with the date have the same Ship Date until the next row with a Ship Date then all the Items have that Ship Date, and so on. Is there a way to code in the Advanced Editor something that will get the Ship Date and apply it to all following rows that have no Ship Date until the Ship Date changes (then apply that Ship Date and so on)?
Any other ideas on how to get the Ship Date on each row?
Solved! Go to Solution.
In the Query Editor - right-click on the ShipDate Column Header and select => Fill => Down
In the Query Editor - right-click on the ShipDate Column Header and select => Fill => Down
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 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |