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 all,
My first post, so if any suggestions please let me know.
I got a column with client names, I want to delete some rows with a specific name; all names with a suspense account in it. I got a list with these names I want to delete, just don't know how. Any suggestions?
Thanks,
Paul
Solved! Go to Solution.
Hi @Anonymous
You can not use DAX to delete rows, but you can exclude them as in the example below.
Measure = CALCULATE( SUM( 'Table'[Value] ), KEEPFILTERS( 'Table'[ID] IN { "A", "D" } = FALSE ) )
Hi @Anonymous
You can not use DAX to delete rows, but you can exclude them as in the example below.
Measure = CALCULATE( SUM( 'Table'[Value] ), KEEPFILTERS( 'Table'[ID] IN { "A", "D" } = FALSE ) )
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 |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |