Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
snifer
Post Patron
Post Patron

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
Greg_Deckler
Super User
Super User

Can you show an example of the output you want?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

 

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.