Forum Discussion
Solved
How to create a parameter with dynamic Date query list
I want to create a Power BI report for sales forecasting. The report should present opportunities whose Date is equal to current month and future months in 12 month max. Suppose the oppotunity table...
We're getting there 😄
You can't compare date and datetime types.
Change the StartOfCurrentMonth query to...
// StartOfCurrentMonth let Source = Date.StartOfMonth( DateTime.FixedLocalNow() ) in Source
Did you do this step first?
If you have, you should be able to do something like...
(replace placeholder with your date column name)
let
Source = CommonDataService.Database(
"XXX.com"
),
dbo_lvs_opportunityforecast = Source{
[
Schema = "dbo",
Item = "lvs_opportunityforecast"
]
}[
Data
],
#"Filtered Rows" = Table.SelectRows(
dbo_lvs_opportunityforecast,
each
[
ReplaceThisWithTheNameOfYourDateColumn
] >= StartOfCurrentMonth
)
in
#"Filtered Rows"
I renamed Query1 and unchecked Enable Load, it shows a new error:
Bingo!! the query is working!! Thank you so much for sharing and being patience with me 😃
We're getting there 😄
You can't compare date and datetime types.
Change the StartOfCurrentMonth query to...
// StartOfCurrentMonth let Source = Date.StartOfMonth( DateTime.FixedLocalNow() ) in Source