This is what I exactly need! Thank you so much Sir. Keep it up❤

Awesome video! I came here looking for one thing specifically and learned so much more!

Great video! Here's a copy of your code to gather the most recent date. Is latest month = 'Fact Table'[Refresh Date] = CALCULATE ( MAX ( 'Fact Table'[Refresh Date] ), FILTER ( ALL ( 'Fact Table' ), 'Fact Table'[Company] = EARLIER ( 'Fact Table'[Company] ) ) )

This is excellent, thank you so much for sharing your knowledge

Thank you very much. Your tutorial is very helpful.

Thank you for this video. The Earlier function bit was confusing, do you have a video on that?

This is great! Thanks I hope to apply it in my Primavera P6 reports

You are great bro this will work

Brilliant, didn’t realise you could do this. Thanks

Simple and sweet

very good. thank you

Could I ask if there is any downsides to using such a feature? Like reaching the max data file size etc? Thank you for the great video!

Very helpful video

Thank You

How can we do with two different sets of data I have two different sources and each has its own monthly data and need to be filtered by date?

Nice explanation bro

Thank you very much! It's just truly helpful and direct to the point! Appreciate it :)

Fantastic video, thank you so much 😊

Thanks its great and precise, i come across this tut while i search auto data getting from ftp server folder to powerbi once the source path(FTP Server with Credential) is given. Hence, may you do that.

Very good tutorial, is this guy still posting helpful video tutorials?

Very useful, thanks! But what do I do if I have files of more than one layout (ie some will be additional transaction data and some will be updated static customer info) that i want to update and use?

Could you please show how to do that in online SharePoint folder ?

Great video!

Hi does it work the same with SharePoint folder ?

Thanks for your video. How do i have a selector to choose the report i want to display ? for eg, I am able to choose any month i want and the visual display according based on the month i choose. thanks again.

Thank you for this tutorial. My goal is to adapt my PBI reports to use the "Folder" method. Do I need to recreate my reports when using the "Folder" get data option?

How do you create a monthly view from live data . The data is dynamic and keeps changing

Userful. Like!

I used this same method for the excel file with multiple sheets, but the refreshing doesn't work. Do I have to follow some other method.

Awesome!

Can we use an excel workbook with multiple sheets in it and perform the same automation? I'm trying but getting error that 'The key didn't match any rows in the table' And thanks for this video ✌️

Can we connect power bi report with a folder in cloud like SharePoint and perform the same thing that you have described here with the folder in local?

How can you achieve this if the file format is different for a few files?

Brilliant! Is this applicable to updating a worksheet with additional data and refreshing in PowerBI? Kindly advise if you did something extra or it was that simple. Thanks

This is great. Question, if I upload daily files to the folder, how would I track the changes between each file? Line items that drop off, and new ones that are on the latest report? Differences in values? Thank you!

how to set refresh option for current month file where as i dont want others files to get refresh in the folder to increase the efficiency of the power BI.

would this still work if you used the same folder for over a year? like when you get to january 2024 is it still going to take december 2023 as the latest month?

Hi Fernan, I have a noob question. Does this method applies for weekly report? Just change the coding a bit?

Hi, thanks for the video, If we defined transform steps for file which we received by email and upload the same in PBI. Will the system will transform as per steps define. Pls advise.

Hi bro, I don't know what is the 'monthly report'[country] = earlier ('monthly report'[country]) do, can you explain please? as I by reading it I'm not sure if its necessary

Hi There, I am trying to use IslatestMonth = 'Monthly Reports'[Date] =CALCULATE(MAX('Monthly Reports'[Date]), FILTER(ALL('Monthly Reports'),' ')). The issue I have with my second expression is the values are not same across my monthly reports. Is there a way I can use the above measure where I can set the latest date as true when I do not have a common/same secondary expression ?

Hi there, I can't seem to get this to work. All the values come up as true regardless of whether the date is the most recent - the date format is in DD MMMM YYYY, not sure if that makes a difference. Also as well as the date column is there a way to choose the other column for the formula - in this case its (Country), does it matter? thanks. Playing around with this other column I use I can make it better in that it mostly gets the true/ false statement right - but there are lots of trues that should be false. I think its to do with the date format I use - I need it too look at the whole date not just the months as the data goes back more than a year.

What does the filter where you used "Earlier" and country do, time of video: 7:00

Hi I want to connect a folder with same type of files differentiated with dates. This reports placed every week in SharePoint site. I want to connect these all files and create graphs to so weekly progress. Can you help me?

What if I Want to automate monthly data but they're not the same format?

Hi, thanks for the tutorial. I need to do incremental refresh of daily excel data from a shared folder, if I follow the same method will all the files be loaded in every schedule refresh or just the new ones that are added everyday ? Please help me with this, a bit stuck.

Besttt

Ey, do you have a video in which you compare always the last 2 months? I have lots of data monthly, and I just need to find the variations between the last month and the current month... Basically I have the name of all my users (imagine 100), all the products by each user (I have 200 products, so each user has 200 rows), and I have the percentage they have advance in each product. Meaning in January Pedro can have 17% advance in Product 58, and in Febraury he can be also in 17% in the same product (he didn't use it), but in the case he use it, I need to identify the variation... So my question is :P! do you have a tutorial for comparing always the last 2 months?

New columns: "islatemonth"! What happen if the "country" in the last file have some new countries which were not in previous files?

it's so distracting how you are switching the scenes too many times between the screen and yourself. People are busy getting the information with a short and limited time.