March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |