Create measure to display string from file name used in a query

[JulioAlmeida]

Hi,

I'm trying to make a automated/dynamic way to display the date of data using the file name.

Someting like this:

file name: BI_Execucao_Detalhada_Semanal_08.09.2023_.xlsx

and display the message/tex:

"last update: september 8"

Can anyone help me?

Any suggestions?

Best regards,

Júlio Almeida

[isjoycewang]

Hi @JulioAlmeida ,

I think below post explains clearly how to extract file name in the Power Query editor. Hope this helps!
Solved: Get current file name within PowerQuery Editor - Microsoft Fabric Community

[comish4lif2]

Is there a way to do this - to grab the filename of the source of the table - and store that filename as eaither a Measure (preferred) or calculated column?
----->> WITHOUT using a folder import or some solution that involves Sharepoint?  <<-----

[JulioAlmeida]

Hi @isjoycewang ,

Thanks for the replay.

Currently I have implemented the above solution with a card, but I'm looking a more "straightforward" since all the data in the Power BI project querys from that file and I replace it in an weekly base.

After I change the source file of the query the date in the card or other visual element I need the value to be aotomatic updated.

And I'm looking to it with a function that concatenates a text similar to this:

updatedate = concat("last update: "; <string in file>)

Is that possible?

Best regards,

Julio Almeida

[isjoycewang]

Hi @JulioAlmeida,

Is it possible for you to filter the latest file using the date (or date in your file name) in the Power Query editor? This should always produce the latest one without manually update.

If not, I think that adding a cell in excel file might be simpler.
Discussion for reference: Solved: get current file name - Microsoft Fabric Community

= CELL("filename")