Search found 3 matches

by hansfousert
Sat Jul 05, 2014 2:01 pm
Forum: Power Query
Topic: Cannot parse Odata response result - Solved
Replies: 0
Views: 1935

Cannot parse Odata response result - Solved

Two weeks ago I got this error message in PowerQuery (I'm using Excel 2013): Cannot parse Odata response result.jpg It was stranga. Odata feeds that had been working, all of a sudden gave this error. Or... vice versa. Really odd. This week I got a message about the new PowerQuery release. After inst...
by hansfousert
Sun Jun 22, 2014 4:40 pm
Forum: Power Query
Topic: Filter on today
Replies: 3
Views: 2475

Re: Filter on today

Hi Matt, Many thanks for your code. It works like a charm :) While comparing it with my original code I saw where I my thinking went wrong: I should have put the calculation between brackets before doing the comparison :oops: Actually I wanted to go back 6 months from today. I was looking for a #dur...
by hansfousert
Sun Jun 22, 2014 3:51 am
Forum: Power Query
Topic: Filter on today
Replies: 3
Views: 2475

Filter on today

I'd like to filter a Table on a Date field. The Date should be greater than the first day of the month 6 months ago. So, if today is June 21 2014, the date to be used in the filter is December 1, 2013. I've tried a couple of things but none of it works. It feels like I'm close... but still no cigar....

Go to advanced search

cron