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.
Hey guys,
I currently have 3 tables with different data.
I need a new table, with two columns, where data is displayed like this:
Column 1 | Column 2
Row 1 | Name of table1* | Number of rows on table 1
Row 2 | Name of table2* | Number of rows on table 2
Row 3 | Name of table3* | Number of wors on table 3
* manually inserted
How could I create this table using formulas in order to update the values when I update the data?
Solved! Go to Solution.
If you only have 3 tables, I would create a new table as below.
New_table = VAR TABLE1 = "TABLE1" VAR TABLE1_COUNT = COUNTROWS('Table1') VAR TABLE2 = "TABLE2" VAR TABLE2_COUNT = COUNTROWS('Table2') VAR TABLE3 = "TABLE3" VAR TABLE3_COUNT = COUNTROWS('Table3') RETURN UNION(ROW("Table_Name",TABLE1,"Row_Count",TABLE1_COUNT), ROW("Table_Name",TABLE2,"Row_Count",TABLE2_COUNT) ROW("Table_Name",TABLE3,"Row_Count",TABLE3_COUNT)) |
If this helps, Mark it as a solution.
Kudos are nice too.
If you only have 3 tables, I would create a new table as below.
New_table = VAR TABLE1 = "TABLE1" VAR TABLE1_COUNT = COUNTROWS('Table1') VAR TABLE2 = "TABLE2" VAR TABLE2_COUNT = COUNTROWS('Table2') VAR TABLE3 = "TABLE3" VAR TABLE3_COUNT = COUNTROWS('Table3') RETURN UNION(ROW("Table_Name",TABLE1,"Row_Count",TABLE1_COUNT), ROW("Table_Name",TABLE2,"Row_Count",TABLE2_COUNT) ROW("Table_Name",TABLE3,"Row_Count",TABLE3_COUNT)) |
If this helps, Mark it as a solution.
Kudos are nice too.
@VasTg thanks, it looks like it is exactly what I need.
But where should I enter this code?
"Enter Data"?
"New Source" ...?
Thank you!!
It worked. 😀
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |