Forum Discussion
Advocate IIHow to Count Date Wise
Hi Team,
I have data some thing like this :
Date | File |
01/07/2026 | 134343434 |
| 74635577 |
| 24564675757 |
02/07/2026 | 45405645 |
| 325474699 |
| 97436487 |
| 7425742599 |
03/07/2026 | 12243434 |
| 2134 |
|
|
| 469359639 |
| 847564254 |
| 73796 |
04/07/2026 | 78874547 |
| 323435435 |
|
|
| 787546356 |
|
|
| 78567456747 |
05/07/2026 | 9808969 |
|
|
| 111232332 |
| 5666666 |
|
|
| 32323 |
|
|
| 4565636367 |
I need to take count of File as per Date like below :
Date | File |
01/07/2026 | 3 |
02/07/2026 | 4 |
03/07/2026 | 5 |
04/07/2026 | 4 |
05/07/2026 | 5 |
But Power BI giving like this output :
Please let me know how to get like this output :
Date | File |
01/07/2026 | 3 |
02/07/2026 | 4 |
03/07/2026 | 5 |
04/07/2026 | 4 |
05/07/2026 | 5 |
I suggest you to prepare data in advance making date available at all rows.
fill down dates in power query:
Fill values in a column - Power Query | Microsoft Learn
5 Replies
- krishnakanth240
Super User
Hi Rakesk13
Excel data has merged cells for Date so only the first row per date has a value and rest are blank. Power BI reads those blanks as actual nulls which is why count is not grouping
Open Power Query Editor - Transform Data
Right click the Date column header - Select 'Fill' - Choose 'Down'
This copies each date value into blank rows til the next date appears
Click 'Close & Apply'
Hi Rakesh13,
To achieve your desired result, you would have to fill the blanks in your date column.
To do this, you can go to Power Query Editor and use the Fill Down.
Select the Date column and then click Fill >> Down.Output:
R1k91I suggest you to prepare data in advance making date available at all rows.
fill down dates in power query:
Fill values in a column - Power Query | Microsoft Learn- R1k91
moreover, if you've empty lines, remove them
Rakesk13Thanks !! its Help me out.🙂
