Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
96 | |
69 | |
45 | |
40 | |
30 |
User | Count |
---|---|
154 | |
94 | |
62 | |
42 | |
41 |