Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ashraf_SISL
Regular Visitor

Counting Blank in each row

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

 

 

4 REPLIES 4
Mariusz
Community Champion
Community Champion

Hi @ashraf_SISL 

 

Can you provide a data sample?

Thanks

Mariusz

@Mariusz  Could you please check now

@Anonymous  not working

Hi ,

 

Please see below,

 

I want to get the values of working days column(Where there is blank in sales column, it meansDummy Data.png salesman didnt working on that day.

 

Thanks..

Anonymous
Not applicable

@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 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors