Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have two tables, Maxdate - which is having single datetime column with one row and Userdate with single datetime column with multiple rows.
I have to apply maxdate table as a dynamic parameter to the datetime column in userdate table
how to get this, waiting for the help
Solved! Go to Solution.
MaxDate is a table but you want the value from that table.
Try replacing
[SystemModstamp] <= MaxDate
with
[SystemModstamp] <= MaxDate[MaxDateTime]{0}
This takes the first (index 0) row of the MaxDateTime column of the table.
It works fine when I test something similar on my machine, so I'm not sure what's going wrong.
What exactly did you put in the formula bar?
MaxDate is a table but you want the value from that table.
Try replacing
[SystemModstamp] <= MaxDate
with
[SystemModstamp] <= MaxDate[MaxDateTime]{0}
This takes the first (index 0) row of the MaxDateTime column of the table.
thank you so much for the help
Can anyone please help
the report has only the max date table
No Maxdate and Userdate ... Two tables it has... Max date having one row date which I have to convert into parameter and then use it as a dynamic filter in the userdate table
can you share the file excluding the non sensitive data
https://drive.google.com/file/d/1XLgLpj9FYYXU3EHKHELFjGkzTZjyn9UL/view?usp=drive_link
Please download the report using this link