topic Re: Create measure to display string from file name used in a query in DAX Commands and Tips

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

JulioAlmeida — Tue, 12 Sep 2023 08:08:58 GMT

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

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

isjoycewang — Tue, 12 Sep 2023 09:00:30 GMT

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

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

JulioAlmeida — Tue, 12 Sep 2023 11:35:29 GMT

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

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

isjoycewang — Wed, 13 Sep 2023 02:37:50 GMT

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")

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

comish4lif2 — Wed, 25 Oct 2023 20:22:37 GMT

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? <<-----