Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
For the source table below , I have repeated rows one for India and another for Delhi location .
Another for India and Goa location.
I want to hide all those rows with India(marked in bold in the below table) location and want to only keep the rows with Delhi and Goa location .I have many enteries like this so it should be don via some DAX. Please suggest.
Source Indput:
School | location | Averagemarks |
ABC | India | 90 |
ABC | Delhi | 90 |
DEF | India | 89 |
DEF | Delhi | 89 |
DEJ | India | 75 |
DEJ | Goa | 75 |
DEM | India | 97 |
DEM | Goa | 97 |
Expected Output :
School | location | Averagemarks |
ABC | Delhi | 90 |
DEF | Delhi | 89 |
DEJ | Goa | 75 |
DEM | Goa | 97 |
Kind regards
Sameer
Solved! Go to Solution.
Filter Location Column from the power query.
Then save and close the power Query editor.
2. You Can Use DAX Also
Filter Location Column from the power query.
Then save and close the power Query editor.
2. You Can Use DAX Also
Awesome
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |