Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
let
Source = Sql.Database("localhost", "Vendor03_04", [Query="select * from [EOLShiftData] where startts = dbo.GetShiftDate('" & DATE & "','s',1) and endts = dbo.GetShiftDate('" & DATE & "','e',1)", CreateNavigationProperties=false]),
#"Added Conditional Column" = Table.AddColumn(Source, "Shift", each if [Tag] = [Tag] then 4 else 4),
#"Split Column by Delimiter" = Table.SplitColumn(#"Added Conditional Column", "Tag", Splitter.SplitTextByEachDelimiter({"'"}, QuoteStyle.Csv, false), {"Tag.1", "Tag.2"}),
#"Changed Type" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Tag.1", type text}, {"Tag.2", type text}}),
#"Split Column by Delimiter1" = Table.SplitColumn(#"Changed Type", "Tag.2", Splitter.SplitTextByEachDelimiter({"'"}, QuoteStyle.Csv, true), {"Tag.2.1", "Tag.2.2"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter1",{{"Tag.2.1", type text}, {"Tag.2.2", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"Tag.1", "Tag.2.2"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Tag.2.1", "Tag"}})
in
#"Renamed Columns"
hello ,
In this sql query '"DATE"' created parameter but i want to pass syatem date as a defalt function which can refresh my data as current date data available in database
how can i ??
Solved! Go to Solution.
@Anonymous,
You may refer to the code below.
& Date.ToText(if DATE is null then DateTime.Date(DateTime.LocalNow()) else DATE) &
@Anonymous,
You may refer to the code below.
& Date.ToText(if DATE is null then DateTime.Date(DateTime.LocalNow()) else DATE) &
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |