This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
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}},
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 7 | |
| 5 | |
| 4 | |
| 4 | |
| 3 |