Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
Hello,
I have people who register for the days on a site I am looking to calculate the number of Incris per day, knowing in a day 10 people can write in a day and each in their own ID.
The SQL is like this
Select Date_Registration, Count (*) from members group by date_Registration I don't if the can help you
Thank you in advance for your assistance
hello @amitchandak , you don't see the datas now I Show that. As an exemple the 07/12/2021 11 people registered at the same time at 15:20, I like calcul per each day the sum of the people who suscribe in the at. some time the can registered at different time but I need to know the sum of each day who registered. I hope you undersand now. Thanks before.
Hi,
Share some data and show the expected result.
Hello @amitchandak, it not good, I come to test. I test the sql, is the same like that : Select , Count (USER_ID) from members group by date_Registration
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
85 | |
70 | |
68 | |
51 | |
32 |
User | Count |
---|---|
115 | |
100 | |
74 | |
65 | |
40 |