FutureTargetVSSales

Dear All,

I have one table Items_M where itemid,subclass is there

I have one table sales table where Transaction data there

I created one target table TGT_Prj which will have mont, year , I haev standard date table also

My YTD mesaures is =calculate(totalsum,dateadd(datesytd(dates[date]),-1,year))

Target and here target will be future month target also,

so I want  to see sales vs future target/Target , if suppose i see august report then only target will shwo , sales will come zero like that

I have target item id wise month wise , on item id can repeat in other months

What I did I created one column in power bi m_tgt=date(TGT_Prj[year],TGT_Prj[month],01)) then MTDTGT=totalmtd(sum(m_tgt[target],TGT_Prj[m_tgt]) but givgin me i am creating a report

with month from TGT_Prj table in column and sales from sales table sum(sales) givign me wrong results.

I want  to see sales vs future target/Target , if suppose i see august report then only target will shwo , sales will come zero like that