Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register 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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
74 | |
57 | |
38 | |
33 |
User | Count |
---|---|
71 | |
65 | |
58 | |
50 | |
47 |