Forum

Hi Claudine, I've not experienced this error before, however fellow Microsoft MVP Sergei Balkan wrote this post on the possible causes. I hope that...

Hi Michael, There's no refresh settings in Power BI Desktop as this app is intended for your design process. You'd need to publish the report to th...

Hi Paul, Is the network folder a SharePoint folder? If so, the connector is different. If not, then you can edit the M code via the advanced editor...

Hi Donna, I had a few minutes spare, so I created the date table and measure in your file, see attached. Note that you need to use the Date fields ...

Hi Alma, It's great to hear you found my tutorials helpful 🙂 I'm confused whether you're referring to the old query connector or Power Query. ...

Hi Donna, Thanks for clarifying. You want to see an aggregated view of the data and for that you need the time intelligence functions, which requir...

Hi Max, My bad, I misread your request. For the summary table you will have to use a formula like the one below: =SUMPRODUCT(SUBTOTAL(3,OFFSET(N...

Hi Mattias, The Dayorder columns should be in your Date table along with name of day and week of year. You can then connect your DateAndTime15Min t...

Hi M, Welcome to our forum! I recommend you use Power Query to find partial text strings. Hope that points you in the right direction. If you ge...

Hi Beth, You need 4 separate queries here, one for each scenario. The join type will differ depending on the scenario. Have you seen this post whic...

Hi Daniel, Welcome to our forum. In future please be sure to only post your question in one place so that people don't waste time answering questio...

Hi Donna, Welcome to our forum! Your file name contains a percentage sign which prevents it being downloadable by people viewing your question, whi...

Hi Mattias, You should put your fiscal periods in your date table without the times. You may also need this information in your date table with tim...

Thanks for sharing the file, Rick. The date is entered correctly. There shouldn't be any spare/blank rows in the table. This is what's causing the bla...

Hi Rick, Welcome to our forum! Please share your file so we can see what is going on. It looks like the date format in your transactions tab might ...