Jan 17 2020 09:11 AM
I'm trying to filter a table by month using a paramater where a person enters a date and if it finds it a table will return with all the information from that date. I am getting a privacy message on my HumanResources vEmployeeDepartment (2) query. I've looked at many blogs regarding this problem and I'm having trouble understanding how to fix it. Please help. Thanks.
Jan 17 2020 12:22 PM
Jan 17 2020 01:27 PM
SolutionCombine parameter query with main one like
let
//HireDate = DateParamQuery,
HireDate = Date.From(
Excel.CurrentWorkbook()
{
[Name="DateParamTable"]
}[Content]{0}[StartMonth]
),
Source = Sql.Databases("KANEFF"),
...
Jan 18 2020 08:32 AM
Jan 17 2020 01:27 PM
SolutionCombine parameter query with main one like
let
//HireDate = DateParamQuery,
HireDate = Date.From(
Excel.CurrentWorkbook()
{
[Name="DateParamTable"]
}[Content]{0}[StartMonth]
),
Source = Sql.Databases("KANEFF"),
...