Make an Excel file crash at a specific date

[LucaA]

Hi guys,

i would need to include a query (in PQ) /dax formula in (power pivot) to make a file crash at a specific date in the future.

anyone knows a way to achieve the goal?

I would not want to use additional VBA code

Thanks in advance for any suggestion

Bye 

Luca

[v-alq-msft]

Hi, @LucaA 

If you want to use the latest file, you may try to create a function in Power Query, which always loads the newest created file using folder connector.

First you need to create a blank query and paste the codes in 'Advanced Editor'.

let
    Source = (Path as any) => let
        Source = Folder.Files(Path),
        Custom1 = Table.SelectRows(Source,each [Date created]= 
    Table.Max(Source,"Date created")[Date created]
    )
    in
        Custom1
in
    Source

Finally you may input the folder path to get the newest created file in the folder.

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[LucaA]

@v-alq-msft

thank you for the idea,

i will use it.

but what i can do if the file has been downloaded in local?

thanks

Luca

[Anonymous]

So you want to sabotage the file?  

[LucaA]

Yes, something like that. I need to stop the use of an old version and be sure that anyone is using the new one at a specific date in the future.

[spg_vizcube]

The only way I know is using Powershell to delete this file, is this file hosted on cloud or on a drive? 

Appreciate your Kudos!

If I solve your problem, please accept this as a Solution

Add me on Linked In , Visit my blog vizcube.biz
Subscribe to my youtube channel 

[spg_vizcube]

Not sure if I get your question right, What do you mean by Crashing the excel sheet?