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,
I have a data as per below,
A,B & C are the salesman & 01/05 02/05 03/05 are dates
As per data, A worked for 02 days, B for 01 day & C for all 03 days
I want to create a new column "working days" here, How to do that.
01/05 02/05 03/05 Working Days
A 10 12 2
B 11 1
C 13 12 15 3
Regards,
Ashraf
Hi ,
Please see below,
I want to get the values of working days column(Where there is blank in sales column, it means salesman didnt working on that day.
Thanks..
@ashraf_SISL Please try below solution and check if it works
1. Go to edit query
2. Select all the column in among which you want to find non blank values
3. Click on add column tab
4. Click on statistics and select count values option
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.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
68 | |
48 | |
45 | |
18 | |
15 |