Querys in Power BI

[Ramanjaneya]

Hello Team,

We have requirement in Power BI, I have reviewed and suggested few things to business which are not doable in Power BI. Please suggest/add your comments if it is possible in Power BI.

Requirement:

1. We need to create 2 sheets in YTD paid report 
         a. Summary sheet
         b. Data sheet
2. We have multiple calculations in Summary sheet Please find the below screenshots for your reference.
3. By default, when user export the YTD report in excel it should download both summary and data tabs at a time. Please confirm is it doable in Power BI?

Thank you!

 @Sahir_Maharaj , @bwarner87 , @CHaines 

[CHaines]

Here is a discussion from within this community involving people who clearly know more than me Export data from Power BI desktop into multiple ta... - Microsoft Power BI Community

[CHaines]

It looks like Power BI's native export goes to .csv files, which don't support tabbed data. Power BI supports R and Python coding, so you can definitely do something there. a quick google search gave this Power BI example using R code - https://youtu.be/2V9cLPXPemg

Here's a how to on the R code iteself R: How to Export Data Frames to Multiple Excel Sheets - Statology and the R package guide openxlsx package - RDocumentation

Here's and equivalent Python guide How to Write Pandas DataFrames to Multiple Excel Sheets? - GeeksforGeeks

[Ramanjaneya]

@Sahir_Maharaj , @bwarner87 , @CHaines - Can you please replay, if you know the solution for above quetion.

Thank you!