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 Experts,
How easily I can get this result as in picture with explanation
For huge list of data, I am looking for simplest way to get the output ?
In this case of the data, Column C, Status is filtered for YES 2. Column D Oper is filtered for Active & In Use and then removed the duplicate count from Column A so i get 4. Note: In my work, I have many columns.
Your kind help is appreciated.
Best Regards
Solved! Go to Solution.
@acerNZ Can you not consider removing duplicates for column A.
And then apply filter on colums status and Oper?
@Anonymous Yes you are right once, this was done. I could able to filter and Now I need to work on dates. Thanks a lot
@acerNZ Can you not consider removing duplicates for column A.
And then apply filter on colums status and Oper?
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.