topic Re: Product wise SKU wise Month till date vs (Month till date Last Last Year) in DAX Commands and Tips

Product wise SKU wise Month till date vs (Month till date Last Last Year)

DeepDive — Fri, 12 Jul 2019 13:41:04 GMT

Hi All,
I have sales data ( till date data )with Invoice date. Connected to dim table. I want to calculate product wise sku wise sales Current month ie from 1st July to 12th July current year and want to compare it with 1st july to 12 july Last year. Data get refreshed daily, So I would need dynamic dates here in dax.
resuslt would be like.. Product Brand then SKU then sales of ( 1st July to max(invoive date) ie yesterdays date of current year.. then same period sales of Last year ( 1st july to 12th last year).
Experts pls provide solution.

Re: Product wise SKU wise Month till date vs (Month till date Last Last Year)

Anonymous — Mon, 15 Jul 2019 21:09:26 GMT

You don't get any answers because the description of the problem is not human-readable.

Best

Darek

Re: Product wise SKU wise Month till date vs (Month till date Last Last Year)

DeepDive — Tue, 16 Jul 2019 03:42:07 GMT

Hi Anonymous ... thanks for your reply. Will take care of this next time.