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
rubayatyasmin's avatar
rubayatyasmin
Icon for Community Champion rankCommunity Champion
2 years ago

Hi, Anonymous 

 

you need to create some calculated column to achieve the goal.  please find the attached solutions file. 

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi rubayatyasmin ,

Thanks for your quick response, I'm using a dataset that's common to multiple reports where we will create columns only if there is no way to achieve the result in measures. It will be great if you could help with measures for the scenario below.
I should have clarified this. I have a Calendar table for dates, Customer table for ID , VOL & TGT from 2 different fact tables. But all are related .