Forum Discussion

rmcgrath's avatar
rmcgrath
Advocate II
1 year ago
Solved

Dynamic start and end dates?

Hello - I used the "Download with Live Connection" option to get the data from a Power BI Report into Excel.  The code below is the code for this Live Connection.  Since it is a Connection and not a ...
Need Help
Show and Tell
Tips and Tricks
  • GilbertQ's avatar
    GilbertQ
    1 year ago

    Hi rmcgrath 

     

    Could I ask you a question? And what are you trying to achieve by extracting all of your financial information into excel? Is this for data extract or is this to do some further analysis? 1 way you could do the dynamic date is by using the Timeline Slicer in Excel. Which had been limit the range of dates?

     

    Also have a look at this: Consuming a DAX query in Excel – Unplugged #5 - SQLBI

GilbertQ's avatar
GilbertQ
Super User
1 year ago

Hi rmcgrath 

 

Could I ask you a question? And what are you trying to achieve by extracting all of your financial information into excel? Is this for data extract or is this to do some further analysis? 1 way you could do the dynamic date is by using the Timeline Slicer in Excel. Which had been limit the range of dates?

 

Also have a look at this: Consuming a DAX query in Excel – Unplugged #5 - SQLBI