Forum Discussion
Running Count based on Data Version, Product, and Request Date
Hello Everyone, I am new to all this and getting pretty twisted up in what I think should be an easy solution after weeks of trying to figure it out for myself on this community forum and other sour...
Anonymous My bad, that's what I get for not setting up the model and testing properly. I believe this should do it and PBIX is attached below signature. Thanks for sharing the PBIX, really helps.
Count Req Date Column = VAR __Product = [Product] VAR __ReqDate = [Req Date] VAR __Date = [Data Version] VAR __MinDate = MINX(FILTER(ALL(Table1),[Product] = __Product && [Req Date] = __ReqDate),[Data Version]) VAR __Result = ( __Date - __MinDate ) * 1. + 1 RETURN __Result
Brilliant! Worked perfectly. Thanks for the guidance. Slowly making progress on my project.
Cheers!