Multiply all columns of a table to 1 column of a table.

[Asina]

I am trying to make a table act as a form of filter to a bunch tables.

My idea is to multiply an entire table with a single column of the table i call filter. 

The table called filter has 5 columns, where 1 column is Time with 24 rows of data ranging from 0 to 23.

All of the other tables also has The same Time Column, which is used as relation in the model to link with the filter table.

The question is how can i multiply an entire table into 1 column and where would the output data be ? 

Can I used a measure to act as such or should i create the same amount of columns for each output of the table?

Thanks

[Dhacd]

@Asina 
You need to create a measure for all 5 columns and use that measure where ever you need to call the multiplied value.

If this post helps, then please consider accepting it as the solution to help the other members find it more quickly.

Thanks and Regards,
Atma.

[Asina]

There must be a better solution. Since I have several tables with each ranging from 5 column to 20 column... If I have to create 80 measure...I would rather put the entire thing in an excel and go the old fashioned way. 

[Dhacd]

@Asina 
The link is the closest I found online for your problem. You can do this in the powerquery

Inside the table.transformation function after every "each_" use the constant value which you want to use to multiply the fields

Pros:

1. You can change the constant easily if you create it as a parameter.
2. You don't need to do this every time. for the same data set when it is updated.

 Cons:

1. Every time when you add a new column you need to do the same for the new column.
2. The time taken to implement this for the first time is huge.

Link 
If this post helps, then please consider accepting it as the solution to help the other members find it more quickly.

Thanks and Regards,
Atma.

[Asina]

Unfortunately this is not a solution i am looking for. I have disgarded the issue