The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All
I was trying to group by my data by Receive Hour as i need to know the sum of number of tests received per hour but i m getting the following. does anyone know the solution?
Hi @SINGHTX9,
Please follow MarcelBeug's suggestions in below links to check your problem:
Expression Error.: The key didn't match any rows in the table
The key didn't match any rows in the table. Table
Best regards,
Yuliana Gu
Hi Yuliana I tried all the possible suggestion mentioned in the post but still the error hasnt gone. My fear is that my file has been corrupted as now i cant prpgress any further with building my dashboard because whenever i go to edit query mode, the same message appears.
Please help me urgently.
Hi
You can do this in DAX, and it is better too as it dont consume your memory.
Cretae a measure SUM( table1[No.of Test] ). Pull the recive hr field and the measure to gett he no of test taken by receive hr.
Thanks
Raj
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
96 | |
80 | |
62 | |
56 |
User | Count |
---|---|
261 | |
120 | |
113 | |
83 | |
71 |