Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Make an Excel file crash at a specific date

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

Need Help

6 Replies

  • spg_vizcube's avatar
    spg_vizcube
    Icon for Helper II rankHelper II
    6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    So you want to sabotage the file?  

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        spg_vizcube
        Icon for Helper II rankHelper II
        6 years ago

        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 

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi, Anonymous 

     

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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