Forum Discussion
Help-Really Struggling with My Data
Not to worry. i've figured it out now.
i had to use measures on the specific tables that i'm working on.
once i'd created the measures as you'd advised i was able to use the date table and create a new table to show the values i wanted.
i've now got a complete set of values that show invoices paid for all services and generated graphical images for it.
next step on this one is to complete a percentage change over time. and then i'm set on this part of the financials and i can move on
Community ChampionYou do not need to append the tables. Your can calculate from different tables and then add the measures.
First Step: Pull in the tables you want to use.
Second Step: Create a simple SUM calculation to total thecolumn in the table.
Format to follow for all columns to sum is Total = SUM(TableName[ColumnName])
Fees by year = SUM(qryFeesAllocations[fees by year])
Total Fee = SUM( qryFeesAllocations[total fee])
Invoice Paid = SUM(qryOffersAndSales[Invoice Paid])
SalesFeeinCVAT = SUM(qryOffersAndSales[SalesFeeincVAT])
Third Add a date table and connect the data tables to the date table using relationships. Date Table info here: https://community.powerbi.com/t5/Desktop/Creating-Date-Tables/td-p/553980
Fourth: Create a measure to sum your other measures just give a name to this measure and use other measure names in the calculation. Format example: FEES = [Fees by year]+[Total Fee] Use your discretion on this.
Fifth Create your table. Use your date table to populate rows so drop your year on the row and the value from the measure you created.
Using the date table, you can also use time intelligence to create totals for previous year to use in your growth %.