I need help to create a new table from another one
I don't know if this is tricky or is just me, but here goes nothing. I have one table with a group of columns that are months and another group of columns that are also months, each group have a different context in its values; one group is a planified budget, the other group is the real disbursement. Something like this: id title jan_planified_amount feb_planified_amount (…) jan_real_amount feb_real_amount (...) 1 example_1 $500,00 $0,00 (…) $0,00 $500,00 (…) So I tried creating two new tables, one for each group and unpivot the columns, keeping the ids, the months and the amount. Then I create a relation many to many and create a new table with only ids, but when I tried putting the values in a chart it does not work. So I need another way to relate these tables or create only one table with both values like this: id title month planified amount real amount 1 example_1 jan $500,00 $0,00 1 example_1 feb $0,00 $500,00 1 example_1 mar $1.000,00 $1.000,00 1 example_1 apr $0,00 $0,00 1 example_1 may $0,00 $0,00 1 example_1 jun $0,00 $0,00 1 example_1 jul $0,00 $0,00 1 example_1 aug $0,00 $0,00 1 example_1 sep $1.000,00 $0,00 1 example_1 oct $0,00 $0,00 1 example_1 nov $0,00 $0,00 1 example_1 dic $1.000,00 $2.000,00 Because I need a chart like this: Been the bars the planified amount and the line the real amount. I don't know if this is the best way to achieve this but is the only thing I cant think of. I need a little help.
Create new table with distinct values and filters
I want to create a new table that contain a distinct value of SKU. However, when I try with filters, the distinct values can not comply with the DAX code so I don't know where should I put the distinct code. Here is my code, basically I need the distinct values of SKU along with the brands and their descriptions. I also want to apply the filters where the SKU code must not start with "S", "O" and list of SKU with condition (brand<>blank()&&left(sku,1)="C-") FILTER(SUMMARIZECOLUMNS(ItemPackage[SKU],ItemPackage[PackageDescription],ItemPackage[Brand Name]),LEFT(ItemPackage[SKU],1)<>"S"&&LEFT(ItemPackage[SKU],1)<>"O"&&(ItemPackage[Brand Name]<>BLANK()&&LEFT(ItemPackage[SKU],1)="C")))Creating a table from different columns of each table with date filter and aggregate the column
Hi, I have 8 different data tables with calculated measures & columns. I want to create a new table from columns of each table. basically, Table 1....to Table 8 with approximately 15 columns each what I want is, below New table, column 1 = sum of ( Average of calculated column 1 of Table 1 +...+ average of calculated column 1 of table 😎 Column 2 = sum of ( Average of calculated column 2 of Table 1 +....+ average of calculated column 2 of table 😎 . . . Column 8 = sum of ( Average of a calculated column 8 of Table 1 +....+ average of calculated column 8 of table 😎 All the above-calculated column in the new table will use date slicer in visuals. Help me, please.
