Forum Discussion
Query against dataset
Hello.
I have a PowerApp that I'm using to trigger a flow that query's a dataset on PBI Workspace.
I'll be replacing "hamlet" with a string value from a text box in the PowerApp.
The DAX I have so far is the below, but it's not filtering the way I would have thought. In this case it returns nothing:
EVALUATE(FILTER(LocalHeroes_WarrantySearchTable, LocalHeroes_WarrantySearchTable[Address1] IN {"hamlet"}))
The table would look something like this...
| ID | CustName | Address1 | City |
| 2 | John | 2 Roche Drive | Ayr |
| 3 | Peter | 33 Ester Cres | Dublin |
| 4 | Alfie | 4 Hamlet | Glasgow |
| 5 | Mark | 18 Bomont | London |
| 6 | Emma | 74 Cessnock | Manchester |
What I want the DAX to do is, search the [Address1] column for any values that contain "hamlet", and then return that row or rows of data.
so:
| 4 | Alfie | 4 Hamlet | Glasgow |
Anonymous,
Try this:
FILTER(LocalHeroes_WarrantySearchTable, CONTAINSSTRING(LocalHeroes_WarrantySearchTable[Address1], "hamlet"))
2 Replies
Anonymous,
Try this:
FILTER(LocalHeroes_WarrantySearchTable, CONTAINSSTRING(LocalHeroes_WarrantySearchTable[Address1], "hamlet"))DataInsights awesome, thanks