Forum Discussion

JDeMaro22's avatar
JDeMaro22
Frequent Visitor
3 years ago
Solved

PowerBi, Duplicating table w/ specific date range

Hello,

 

I'm trying to copy over PowerBi Tables to Excel but there is too much data to bring over. How can I duplicate a table in PowerBi and filter out only 2022/2023 data? If I remove the previous years of data I would assume the data set would be small enough to paste into Excel. 

 

* Note the "PaymentYear" is a measure I wrote off the "Payment_Date" column

 

Thank you very much,

 

 

 

  • Hello JDeMaro22 ,

     

    filter the payment year to 2022/2023 and then right click on any column and click copy table then go into excel and paste it.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin

1 Reply

  • Hello JDeMaro22 ,

     

    filter the payment year to 2022/2023 and then right click on any column and click copy table then go into excel and paste it.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin