Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all, can you help me please.
I am trying to use calculated column to show latest month report when they upload the new .xlsx files in my sharepoint folder online.
Hi @Kinley1
In which table did you add this calculated column? Do you have a table named as "Sample" in your model?
If you have a table named as "Sample" and add a calculated column in this table, you will have below result. Is this what you want? Please note that this formula is DAX formula not Power Query.
If you want to load data from a sharepoint folder, please refer to Combining Excel Files hosted on a SharePoint folder with Power BI | Microsoft Power BI Blog
If you only want to load data from the newest file into your model, you need to filter that in Power Query Editor. After that, you have to refresh data to import the latest data from the sharepoint folder.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hello @Idrissshatila
Query still cannot find my sharepoint online folder 'Sample'. The error reads "Cannot find table 'Sample'"
Is there any way to how we put sharepoint folder in the power queries
Hello @Kinley1,
try it like this:
Latest Month = CALCULATE(
MAX('Sample'[Date])
, FILTER(ALL('Sample')
, 'Sample'[Country] = EARLIER('Sample'[Country]))
)
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |