Forum Discussion

Ahmedx's avatar
Ahmedx
Super User
3 years ago

pls try this

Flag Column = 
VAR t1 = [Product]
VAR t2 = [Customer]
VAR t3 = [Week]
VAR _tbl = SELECTCOLUMNS(ADDCOLUMNS( GENERATESERIES(1,53), "Step", [Value]&","&[Value]+1 &","&[Value]+2),"Step",[Step])
VAR _Result = CONCATENATEX(FILTER(ALL('Table'),'Table'[Product]=t1&&'Table'[Customer]=t2),[Week],",")
RETURN
  IF(MAXX(FILTER(_tbl, CONTAINSSTRING(_Result,[Step])),[Step]), "Y","No")

  • sanc_152's avatar
    sanc_152
    Helper I
    3 years ago

    Hi Ahmedx 

     

     Thanks for your hardwork and prompt reponse.
    the Dax you have given to me it is only finding the patern whether it available or not .but my requirement is little differnt.

     

     

    in the screenshot above for product 1 there are 2 customers a,b respec. and we are sending the same product to 2 cutsomers (a,b)within the same time frame week1,2,3 and it ismore than 2 weeks .So I want to consider only those product and customer with ahving same time frame and assign a flag As Y

     

    Hoppefully  now it is clear .

     

    Best Regards

    san