Repeat ID within a Rolling 12 month calculated Column
Hello All, Unfortunately, I am unable to share my data for security reasons. I am looking to create 2 columns depending on Category 1 or 2 equalling YES, it will tell me if the customer ID has appeared before within the last 12 months and if so how many times. an example of my data is below Row ID Date customer ID Category 1 Category 2 1 01/01/2022 1 YES NO 2 01/01/2022 2 YES NO 3 01/02/2022 1 NO YES 4 01/03/2022 1 YES YES any help would be great, THANKS ALL
Sum of Next 7 Day Sales
This is a 2 part question: today is 7/13/22 I am trying to calculate my COGS for the next 7 days based on LY COGS. I started my measure with trying to calculate LY COGS but as you can see in the photo below they seem to be off by 1 day...what am i doing wrong? COGS Next 7 = CALCULATE( [COGS], DATEADD('Date'[Date], -1, YEAR)) Once I have that I would like to do a rolling sum of 7 days looking forward. so my true COGS Next 7 would equal LY COGS 7/13/22-7/19/22 - 82,858 How do i create that DAX??? PLEASE HELP 🐵
