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,
I'm trying to create a calculated table where all those that have failed data validation end up.
The data validation is done in the table so I need to filter on the column in there when it equals 1. My only issue now is only bringing back certain columns into that calculated table as only a few are required.
Table = FILTER(AllTagExtracts, AllTagExtracts[ExtractDUNS Equals ERDDUNS Ind]=1)
As always, any help is appreciated.
Solved! Go to Solution.
Use SelectColumn like
Table 2 = SELECTCOLUMNS(filter(Data,Data[Salary1] > 10),"Department",Data[Department],"Salary",Data[Salary1])
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.
Use SelectColumn like
Table 2 = SELECTCOLUMNS(filter(Data,Data[Salary1] > 10),"Department",Data[Department],"Salary",Data[Salary1])
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.
That's how SELECTCOLUMNS works. Was one of the functions I was looking at but didn't know was a custom name you had to provide for the column header. Thanks very much @AnkitBI
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 |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |