Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I'm new to Power BI and trying to basically created a calculated column in Power BI to add up some payments based on specific filters, in Excel I would use the following to create the filter column:
=IF(IF(COUNT(SEARCH({"97356719"},AT2)),"Code","Non Code") = "Code", "Code",(IF(COUNT(SEARCH({"Customer1","Customer2","Customer3","Customer4","Customer5","Customer6"},M2)),"Fixed Price","Not Fixed Price")))
AT2 and M2 are the data columns
is there a way to layout the DAX code to test two different column of data and mutiple string matches in each?
Hi @DavidSasse ,
Could you please share your sample data or desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Amy
Just wondering if anyone can help me
The link to your data has expired. I suggest starting a new thread (with a link to your data) and try to explain better what you want.
For example, Here is the current data
xxxxx xxx
Here is what I want returned
yyy
and here is the logic to make that happen
User | Count |
---|---|
86 | |
83 | |
69 | |
67 | |
55 |
User | Count |
---|---|
125 | |
100 | |
90 | |
84 | |
66 |