Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
What is currect way to replace below values with dynamic parametars. I would like to get data from SAP BW for last 12 months and I need to create dynamic parametar to replace these values. For example next month the values would be - "DATEFROM", {"2022-02-01"}}, and "DATETO", {"2023-02-01"}},. This has to be changed dynamic.
= Cube.Transform(CPRL,
{
{Cube.ApplyParameter, "DATEFROM", {"2022-01-01"}},
{Cube.ApplyParameter, "DATETO", {"2023-01-01"}},
Solved! Go to Solution.
This is what I have built. Now it seems to work correctly .
date_from = DateTime.Date(Date.AddMonths(DateTime.LocalNow(), -12)),
date_to = DateTime.Date(DateTime.LocalNow()),
date_from_formatted = Date.ToText(date_from, "yyyy-MM-dd"),
date_to_formatted = Date.ToText(date_to, "yyyy-MM-dd"),
#"Added Items" = Cube.Transform(YourTable),
{
{Cube.ApplyParameter, "DATEFROM", {date_from_formatted}},
{Cube.ApplyParameter, "DATETO", {date_to_formatted}},
This is what I have built. Now it seems to work correctly .
date_from = DateTime.Date(Date.AddMonths(DateTime.LocalNow(), -12)),
date_to = DateTime.Date(DateTime.LocalNow()),
date_from_formatted = Date.ToText(date_from, "yyyy-MM-dd"),
date_to_formatted = Date.ToText(date_to, "yyyy-MM-dd"),
#"Added Items" = Cube.Transform(YourTable),
{
{Cube.ApplyParameter, "DATEFROM", {date_from_formatted}},
{Cube.ApplyParameter, "DATETO", {date_to_formatted}},
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.