Forum Discussion
Solved
Combo chart with target line
Hi community, I have my sales data set in 2 tables: Table 1: sale id, date, customer id, supplier id Table 2: sale id, item id, price, discount, currency From the above tables i calculate t...
netpharma,
Please create a measure in your sales table using DAX below and then drag the measure to Line values of your combo chart.Measure = CALCULATE(SUM('Table 3'[target]),FILTER('Table 3',MONTH('Table 3'[date])=MONTH(MAX('Table 1'[date]))))
Regards,
Lydia
netpharma,
Please create a measure in your sales table using DAX below and then drag the measure to Line values of your combo chart.
Measure = CALCULATE(SUM('Table 3'[target]),FILTER('Table 3',MONTH('Table 3'[date])=MONTH(MAX('Table 1'[date]))))
Regards,
Lydia
Is it work for 3 target? So ,it will be 3 lines in same chart!