cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
snifer Member
Member

modify table during loading queries

I got a table where accounting table where 

 

accountamontmonth
10021
12031
13041
14051
10022
12062
13002
14072

 

I want display matrix,

columns month

 

row account

 

how i can do if i want display as row all account

and then have account 120-100

can i do this in querying?

2 REPLIES 2
Super User
Super User

Re: modify table during loading queries

Can you show an example of the output you want?


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

snifer Member
Member

Re: modify table during loading queries

 

the result must be a MATRIX:

I guess the best way to do it is by making a calculated table but i don't know how to proceed

ref.(https://community.powerbi.com/t5/Desktop/Power-BI-desktop-create-a-Calculated-Row-in-Matrix-Visualis...)

 

 month  
matrix12 
account   
10022 
120-130-16 
14057 

I need to display a matrix but I need to have a calculation in the middle row of the matrix.

 

in the example account 120- account 130 = for month 1 ->3-4=-1

for month 2-> 6-0=6

@Greg_Deckler 

 

this is how I wish to display it

regardings months I would need to display in the matrix the last 12 months running and not the calendar year

Capture.PNG

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,038)