cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shubs Regular Visitor
Regular Visitor

Replicate Excel table in Power BI

Replicate.PNG

 

Hello All,

 

I want to create a Table matrix in Power BI as similar to the screen attached. We have names of the measures in the first column(Measure Names) and values of that based on the type of calculation(Like YTD, Prior Month/Period, Current Month/Period).

How to achieve this kind of table in Power BI?

Excel works on the cell level and thus we can create it easily, but in Power BI it works on the full column. Please help me with this.

 

Thanks

Shubs

4 REPLIES 4
Community Support Team
Community Support Team

Re: Replicate Excel table in Power BI

Hi @Shubs,

 

I'd like some sample data for test, you can upload it to onedrive or google drive and share link here.

 

Regards,

Xiaoin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Shubs Regular Visitor
Regular Visitor

Re: Replicate Excel table in Power BI

Hi @v-shex-msft,

 

Thanks for your response. But, I can't share the data because of some security. Let me explain my scenario.

 

Let say I have 4 measures as Total Sales, Total Purchase, Total GM, and Total GM%. Now, I will create time comparison like YTD, MTD, Prior Month, Current month etc for each of these 4 measures which will work with the date range selected.

 

Now, I want to display it in Power BI with the help of Table Matrix as I have to replicate the Excel in the Power BI. We all know that excel functions work on each cell while DAX works on the full column. So I need to create something to achieve this case, maybe some summarize table or something.

 

I am not sure how to achieve this in Power BI. Can you please help me with this?

 

Thanks

Shubham

 

Community Support Team
Community Support Team

Re: Replicate Excel table in Power BI

HI @Shubs,

 

How about share some fake data with same data structure? It is hard to coding formula without any data structure.

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Highlighted
Shubs Regular Visitor
Regular Visitor

Re: Replicate Excel table in Power BI

Hello @v-shex-msft,

 

Please find the excel file in below link for some dummy data.

https://www.dropbox.com/s/wgypy2udabfml3i/Test%20Data.xlsx?dl=0

 

Thanks