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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I
Helper I




I'm really new in using PowerBI and I'm just trying to study functions and create reports of future implementation.


Some background:

The data I have is already around 500,000 rows. My month column is formatted as YYYY/MM and read as MM/DD/YYYY by PowerBI. All the DDs are 1 since there are no dates. Weeks are formatted as YYYY/WW, but read as WW/DD/YYYY.


I tried using delimeter to create a separate week and month column through query. If I'm not mistaken, I read that I have to duplicate of my current master query and manipulate from there. After creating the three new columns, I removed other columns for easier loading. I don't know if this is right.


After trying to apply, I get this error on the values of my Week column although its format is already a whole number 

"DataFormat.Error: We couldn't parse the input provided as a Date value.


Also, another thing: PowerBI adds a row number column automatically with weird numbers. Is that normal? Do I delete it? Is it related to the indexing, something I read online as well? Thank you guys so much in advance.




Hope you guys can help. I have so much questions and I hope this website can guide me through.

Super User
Super User

What I think you might need is a date table, which you can then use those columns when joining on a date table?

Here is a link to a great blog post which explains this:

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

Super User
Super User

well as far as i can tell this is your problem 2015/13 is not a whole number, a whole number would be 201513 so it looks like it is failing, you will have to clean those values up.

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Do you have any suggestion on how to clean the values? It's filtered so I expect the 2015/13 to appear via filter, but all I can see are 1,2,3,...12,...,53, which represent the weeks of the year. I tried searching/expanding the filter list but it says it can't parse the data. Any suggestions on how to do this? Thank you.

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.