Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |