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

[DeepDive]

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.

[Anonymous]

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

Best

Darek

[DeepDive]

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