Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Can you please guide me how to write below sql query in dax ?
SELECT sum(revenueamount) from MsSales
where premiersupportmodel in('unifed') and (familyname like '%base%' or familyname like '%add%')
Thanks,
Siva Reddy
Solved! Go to Solution.
Hi @sivareddy123 ,
Try this one, If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
= CALCULATE ( SUM ( MsSales[revenueamount] ), FILTER ( MsSales, MsSales[premiersupportmodel] = "unifed" && SEARCH ( "%base%", MsSales[familyname], 0, BLANK () ) <> BLANK () || SEARCH ( "%add%", MsSales[familyname], 0, BLANK () ) <> BLANK () ) )
Hi @sivareddy123 ,
Try this one, If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
= CALCULATE ( SUM ( MsSales[revenueamount] ), FILTER ( MsSales, MsSales[premiersupportmodel] = "unifed" && SEARCH ( "%base%", MsSales[familyname], 0, BLANK () ) <> BLANK () || SEARCH ( "%add%", MsSales[familyname], 0, BLANK () ) <> BLANK () ) )
You should be able to use FIND or SEARCH in place of LIKE
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |