Forum

Hi Brendan, Please upload your file again and be sure to click the 'start upload' button after selecting your file. Thanks, Mynda

Hi Thulasi, Please upload your file or at least a sample file that illustrates what you mean. It's impossible to say without seeing your data as I ...

Hi Moriel, Welcome to our forum! Like Anders suggested, you can use the Date.FromText function. If you don't have a year column in your data you...

Hi William, Welcome to our forum! Thanks for sharing your file. I can see that your data was originally in the incorrect layout, but you've fixed t...

Not sure why the French settings are working. Perhaps you have that as your system settings? Either way, don't worry too much about whether it's sh...

Hi Eleanor, Thanks for providing further information. I'm still a bit in the dark as to what this data represents, but from what you've explained i...

Hi Carolyn, I wonder if it's a dependency issue e.g. if you have queries that reference each other and they all try to refresh at the same time it ...

Hi Mymalone, You haven't said how you determine completed vs not completed and there are no columns labelled as such. You also haven't said if y...

Hi Kobus, Welcome to our forum! Did you remove the first changed type step before applying change type using locale? Once it's changed incorrect...

Hi Niamh, This post covers custom number formats in Power BI. However, I tried [<1000000] #,##0,K;[>=1000000] 0.0,,M but it doesn't look lik...

Hi Eleanor, Thanks for sharing your files. Just the file containing the Power Pivot model would have been sufficient as we don't need to refresh an...

Hi Alain, Welcome to our forum and thanks for sharing your files. You need to fix the data layout in Power BI to display the pie charts correctl...

Hi Vicky, You can use this formula: =List.Max({ #date([Year],1,1), Date.AddDays( #date([Year],1,1), ( -(Date.DayOfWeek(#date([Year]...

Hi Eleanor, Welcome to our forum! It's great to hear you're making use of the techniques you've learnt in my tutorials. It's very difficult to f...

Hi Mehdi, I would use a VLOOKUP formula on a sorted list to return the status. If you get stuck, please come back to this thread and upload your sa...