Forum Discussion

160475's avatar
160475
Helper I
3 years ago

help in script

dears, good day!!    i have a table named table1 where it shows  date,               employee#,    transaction#  1/1/2022          5656                 123 2/1/2022           6565              ...
Need Help
jaweher899's avatar
jaweher899
Impactful Individual
3 years ago

Hi, here's a community for powerbi and not sql,

 

Please try 

 

SELECT employee# FROM table1 GROUP BY employee#, DAy(date) HAVING COUNT(transaction#) >= 2;