Forum

You can't put a measure in the filter field. If you want a filter that is 'current month' then you'd have to add a column to your source table that cl...

Typically you will use the filter in the value field measures e.g. CALCULATE(expression, filter) If this doesn't work for you, please provide a sam...

Hi Claudine, I'm not sure I understood the requirement, but please see if the measures Puprose >1 and Purpose Blank in the attached file are cor...

Hi William, I'm a bit confused by your description. Each query links to a single data source and then puts the final query result either into anoth...

Hi Claudine, No file attached. Be sure to click 'start upload' and wait for the grey check mark beside the file size before clicking submit. Myn...

Hi Paul, Not sure there's a better way to isolate cell G4 that what you've probably already done. When you 'close and load' choose Connection On...

Hi Claudine, You have two tables in your model with the same names: one called Group Settings and another called Group_Settings. Your PivotTable is...

Hi Paul, Create a new query to get the data from cell G4, then add a column to the original query =#"New Query Name" Mynda

Hi Laura, Welcome to our forum! Your merge query will be triggering all the individual queries to make another call to the website, as explained he...

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...