Overlay income, expense and profit

[unclejemima]

Looking to create an line graph with income, cost of sales and profit each as a line by month

I've got my income and cost of sales as measures and columns per user vega

Income = 
IF(
    Table1[Account] >= 4000 && Table1[Account] <= 4999,
    Table1[Amount],
    BLANK()
)

CostOfSale = 
IF(
    Table1[Account] >= 5000 && Table1[Account] <= 5999,
    Table1[Amount],
    BLANK()
)

 -----------------------------------

Income Measure = 
CALCULATE(
    SUM(Table1[Amount]),
    Table1[Account] >= 4000 && Table1[Account] <= 4999,
    VALUES(Table1[Account])
)

CostOfSale Measure = 
CALCULATE(
    SUM(Table1[Amount]),
    Table1[Account] >= 5000 && Table1[Account] <= 5999,
    VALUES(Table1[Account])
) 

 That being said, I would have to create another measure for income - costofsale = profit.  It would also be nice to have profit displayed as gross margin so probably separate calc for that gross sales / gross profit = gross margin I think.

But even getting the income to overlay the cost of goods on a line graph I can't seem to figure.

help 🙂

[unclejemima · Accepted solution]

Ha, figured it!  I must have been overlooking something simple.

Made a new line graph showing values from colums of  income and costofsales, as well I made a new column for income - costofsales for profit.  Then used the Axis as month.

Voila!

thanks ;-0