Forum Discussion
Need help
I should clarify. Table should the name of your table in your data model. For example, I click on New Measure on Home ribbon to create my measure:
Running % =
CALCULATE (
SUM ( Sheet1[Percentage]),
FILTER ( ALL (Sheet1), Sheet1[Transaction] <= MAX ( Sheet1[Transaction] ) )
)
In this case, my table name is sheet1 because I get the data from an Excel file. Then, I just drag my measure to the matrix
ok i understand that but in the table i have all the information i don't have the transaccions compiled like u, i just have all the transaccions made in a month and the table have this columns code-date-hour of the trans-amount
and inside the matrix i seleceted to show the sum of all the same codes and to show the value by % of the total should i create another table to get the information like u or in this case is another form to do it?