PowerBi, Duplicating table w/ specific date range

[JDeMaro22]

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,

[Idrissshatila · Accepted solution]

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