Forum

Great to hear, Keith. The more you become familiar with Power Query, the more it will all make sense

Hi Terri, This is because you have an older version of Excel than me and that version doesn't have those options. You will have to first load the d...

Hi Keith, Please see lessons 7.03 and 7.04 of the Power Query course on dynamic file and folder paths. You can modify these techniques for your nee...

Hi Grete, Thanks for sharing the file and the analysis you want to do. Some of the measures are self explanatory and relatively straight forward, b...

Hi Gill, Welcome to our forum! Try this where your data is in row 2: =IF(V2="",0,(K2-V2)/365) Or =IFERROR((K2-V2)/365,0) Mynda

Hi Bax, The owner of the Power BI report online should make the dataset available to you via the build permissions in the Power BI service and then...

Hi Antonia, Riny is correct. This is a version issue. You can try updating your version of Excel to see if the feature is available. If that doesn'...

Hi Josh, Welcome to our forum! I'd say the List.PositionOf steps are the bottleneck. You could try wrapping those steps in List.Buffer. This post t...

Hi Eileen, If you're using Power Pivot then you could write a DAX measure for the 3 day average. If you're using regular PivotTables then you'd nee...

Hi Scotty, There was no attachment. You need to click 'Start Upload' after selecting your file and then wait for the grey check mark beside the fil...

Hi Valerie, Yes, a line chart. There's no specific s-curve chart, but essentially it's a line chart. You'll have to write a measure to generate the...

Hi Grete, It's difficult to say without seeing some sample data, but my initial thought is you have too many tables. Dim tables are for data that i...

Hi Michael, If your data is in Excel file A and you use Power Query in Excel file B to get the data and load it direct to Power Pivot, then you can...

Hi Olesea, The process for getting files from a local folder vs a SharePoint folder are different, as you have found. Because of this you can't sim...

Hi Matt, Welcome to our forum! I've moved your post to the Dashboard Course members forum so it gets priority. Without seeing your dashboard and...