Forum Discussion

abaken's avatar
abaken
Regular Visitor
3 years ago

How to a filter A Select command

Hi   I have the following code in a Powerbi query.  How do I change it to select a date range ? Thank YOu    Allister   let Source = GetConsolidatedSQLData("Select accountcode, branchcode, dep...
Need Help
Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
3 years ago

in the SQL you have hardcoded single date, so I assume you need to change the SQL WHERE condition. What is the definition of the GetConsolidatedSQLData measure? It can have some additional logic regarding the date too