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,
I am new to PowerBI.
In my project, I have an Attendance table with 2 Columns as Date and SubProject.
Dates will have dates and SubProject will have a variety of values.
I want to get number of rows with the value InOut in SubProject for the selected dates.
Please let me know how to start.
Thank you in advance.
Solved! Go to Solution.
Hello@Anonymous
For what I have understood your query, you may use Power Query for this.
Post loading the table to Power Query Editor, you may apply the following steps:
The sample data I have created for this purpose:
Go to Transform > Group By
Select the Date column in the Group By window & select Count Rows in the Operation & click Ok
This will give you a summary table with date wise count
Close & Apply
Regards,
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Hello@Anonymous
For what I have understood your query, you may use Power Query for this.
Post loading the table to Power Query Editor, you may apply the following steps:
The sample data I have created for this purpose:
Go to Transform > Group By
Select the Date column in the Group By window & select Count Rows in the Operation & click Ok
This will give you a summary table with date wise count
Close & Apply
Regards,
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
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.