Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Everyone ..
I download csv files from a system every week. Sometimes there is no data for that week. Therefore, if there is no data in that csv, PowerBI will say “this table is empty” for that week's files. How can I change the table to “zero” if there is no data in the csv file of that week. If there data it does nothing.
Column -> Argument /Filters/Count
Thank you !
Hi @u4us1923 ,
As a workaround, you can create a date table with full dates and then merge with your source data to fill in the missing dates.
Here’s a step-by-step guide to achieve this:
1.Create a list of all dates within the range: Refer to Create Calendar Table Using Power Query M Language (mssqltips.com)
2.Merge the list of dates with your data: Merge this list with your existing data to ensure every date within the range is represented.
3.Fill missing dates with zero quantity: Replace any missing quantities with 0.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
use if function with any formula presented in the below youtube post
https://youtu.be/DHB2ejpEGxU?si=CdoQ0wWjh9nOivEV
Thank you for the reply .. but .. I don't want to create a new table. I also loaded data from csv... my question is different. Some weeks there is data for all but some weeks there is no data for http400 or http500. for example; If there is no data for http500 that week I want to create a new row http500 -> Count --> 0 (zero)
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
10 | |
7 | |
7 | |
6 | |
6 |