FutureTargetVSSales

[bilalkhokar73]

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

[v-xulin-mstf]

Hi @bilalkhokar73,

I can't see the screenshot of your issue, could you re-upload it?

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[amitchandak · Accepted solution]

@bilalkhokar73 , Not able to get what is the exact issue. If you joined the date table with both tables then you should be able to get data for sales and Target for all months using date table

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[bilalkhokar73]

https://www.dropbox.com/s/ux9qvvstz70p37r/sample.pbix?dl=0