Like for Like Comparison for same customers/stores

Power BI
1

LfL Sample Data.xlsx (13.2 KB)
Hi All,

I would like to create DAX dynamic formula that compares like-for-like data (sales) for last year for each stores and category of stores. The exclusions are the stores that were closed last year or newly opened stores this year.

Please see attached excel file that provides the logic. I have tried the following logic, but it doesn’t work when I go to the store group level. I have the relevant DAX formulas copied below. The PBIX file is a very large dataset and various connections so I am keeping it simple to explain here.

Like for Like Store Sales = if([Store Sales LY]>0,[Store Sales],0)
Store Sales = sumx(‘Fact Sales Database’,‘Fact Sales Database’[Sales Value])

Many thanks for your help.
Abdul

2

bumping this post

3

Hi @abdul.ali ! We noticed that your inquiry was left unsolved for quite some time now.

Looks like your inquiry was out of the experts and users’ bounds.

We strive to answer ALL inquiries in the forum. However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, you can check out tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!