Forum

Hi Terri, When you emailed me your original question you said the other dates were in columns C and R, but the image and your question above say th...

Hi Arun, It looks like you have pasted your own SQL statement into the 'Advanced Options' field (Get Data From > SQL Server dialog box) rather t...

Hi Juan, What table are you relating to...perhaps you can show me your formula? Note: You can only create a RELATED column between the Orders and R...

Hi John, What happens if you remove the first change type step that PQ automatically applies and then promote the first row as header? If that d...

Very clever! Well done.

You're welcome, Greg. Hope they can fix it for you.

Hi Greg, I've not heard of this error before but a Google search turned up this thread which suggests it was due to virus scan by Trend. Have yo...

Hi Anne, Thanks for clarifying how you arrived at the % Subscription deferred. It was driving me a little crazy 🙂 There is a comprehensive pos...

🙁 I see that occasionally with PivotTables. Sometimes it's quicker just to bite the bullet and rebuild.

Hi Scott, I've not heard of that either. Maybe something has become corrupt between the old PivotTables/charts. Presumably you can build new PivotT...

Hi Anne, I think this is a Power Pivot problem, not a Power Query problem. If the end goal is to have a user see the earned and deferred income for...

@Vasim, that is an Excel formula. Anne needed a Power Query formula, which is what I provided above. @Anne, 😀

That's a shame so much time was wasted, Julian. Glad you have closure though.

Hi Anne, I'm not sure this is the best approach to this problem. Can you please expand on the allocated percentage you want to calculate and subseq...

Hi Anne, You can use Date.AddYears like so: =Date.AddYears([Renewal Date],-[Years]) Mynda