Hi, I am new to PowerBI. I am trying to use a Direct Power Query to retrieve data from a very large SQL Server table to minimize the amount of data uploaded to my pc.
The table contains a column named Report-Week-Date which is the week ending Tuesday of the week the record was created. For example a record created on Monday Dec 11 has a Report-Week-Date of 12-12-2017 for the week of 12-6-2017 - 12-12-2017.
I also only want to load the prior 52 weeks of data. I have been using Crystal Reports for my reporting but want to shift everything to PowerBI. With Crystal I create code to select records on the following criteria....... Report-Week-Date < Current Date and
Datediff("w",(Report-Week-Date), currentdate) < 53. Where I am subtracting the Report-Week-Date week number from the CurrentDate and selecting if it is less than 53.
I cannot get this to work in the Power Query M Language although I can find the matching commands in DAX. Coding with DAX would defeat my intent because the entire table would be loaded to my pc.
Any help would be appreciated.
