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.
Good Afternoon Powerbi team,
I was hoping someone could educate me on the best practice for my issue. I have a solution but I am positive it is the most memory inefficient solution.
Solution is being built in Excel 2013.
The model I am building gets data [an excel file per month] from three folders, so for a full year it is 36 files.
I need to identify the latest date/month these are for so I can apply my forecast to the following months.
For a dynamic solution I am simply referencing the dataset detailed above, remove all other non date columns and filter on the latest value and convert to a list. The problem is everytime it refreshes it checks every file and is time consuming.
Other option is of course to have a named range which the user updates, but I'd prefer a dynamic solution.
Anyone have any ideas?
Hi @NumeritasMartin,
From your description, I could not understand what is your desired result, could you please post more detail pictures about your data structure and your desired result if possible?
Regards,
Daniel He
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |