Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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, departmentcode, transactiondate, transactionamount, periodno, yearno, periodid from GLTRAN Where transactiodate =31/07/22"),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"AccountCode", type text}, {"BranchCode", type text}, {"DepartmentCode", type text}, {"PeriodNo", type text}, {"YearNo", type text}, {"PeriodID", type text},
{"CompanyCode", type text}, {"TransactionAmount", Currency.Type}, {"TransactionDate", type date}})
in
#"Changed Type"
Hi
The code for GetConsolidatedSQLData is below.
I want to leave this code alone if I can as it is used by several queries some of which do not require a date range filter.
How Can I do this ?
Thank You
Allister
let
Source = (sqlstmt as text) => let
AccData1= GetSQLData(sqlstmt,"NLD"),
AccData1c = Table.AddColumn(AccredoData1,"CompanyCode", each "NLD"),
AccData2= GetSQLData(sqlstmt,"AKL"),
AccData2c = Table.AddColumn(AccredoData2,"CompanyCode", each "AKL"),
AccData = Table.Combine({
AccData1c
,AccData2c
})
in
AccredoData
in
Source
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