Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

DAX - Consecutive 3 months target

Hi Team,  Please help with the DAX to count users who achieved target for consecutive 3 months. Any quick help is appreciated. Sample data is given below. ID YEARMM VOL TGT Cosistent_TGT_Ac...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Ahmedx ,

Thanks for your quick response, I should have clarified this. I have Calendar table for dates, Customer table for ID & VOL & TGT from 2 different fact tables. But all are related. In this case, I'm not able to make the WINDOW function work. Please help with this scenario.

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

upload to onedrive

PM me the link