Dax Doubts on CPG data

[HariGanesan]

Hi Guys,

DAX Calculation CPG

Hi Guys, I have a CPG dataset where it has information about the promotions and all of that. Which product is being promoted in what type and in which week and all those. I want to find out how many weeks a product was on promotion. Can you guys help me with this. Its pretty urgent. I have the dates where the particular product is being promoted and where is it being promoted. So now i want the count of weeks it was on promotion. Thanks & Regards, Hari

kindly have a look at this question and help me out. I had attached a mock data in the original post

Warm Regards,
Hari G

[EnterpriseDNA]

Hi @HariGanesan,

Possible solutions have been posted in the previous topic.

Kindly close this post and reply to the old one to eliminate duplicate posting.

Thanks