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.
Dear PBi users,
I've managed to extract data from a very complicated sql database.
I've created the matrix i want, with the good kpis.
I want to study their variation in time, So i want to copy my matrix data into a new table with time indexation every month. Copying the entire tables from my request would make a huge file, as my matrix sums up a lot of rows.
Matrix from sql DB in april
Prjct Kpi1 Kpi2
A 52 33
B 25 14
...
Every month or so, I want to indent my archive table as following :
Date Prjct Kpi1 Kpi2
04/2017 A 52 33
04/2017 B 25 14
...
05/2017 A 55 28
05/2017 B 20 18
...
And so on.
I used to copy my pivot table in excel in my "archive_table" "by hand". How can i reproduce this action?
Thanks in advance!
Solved! Go to Solution.
You could click on the ellipses in the matrix visual, export data and reimport.
You could click on the ellipses in the matrix visual, export data and reimport.
It's indeed what I do, but i hoped there was a direct way to do it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |