Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hi to make if condition with two different tables? this is the command
EXTRACT USERS_ROLE RUSERS_USERID USERS_FR_CCROLE IF (USERS_EFFECTIVE_TO >%_v_Cutoff%) AND (A1_USER_PROFILE.USR02_USERID <> " ") TO A2_USER_ROLES
User | Count |
---|---|
11 | |
9 | |
6 | |
5 | |
4 |