Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
BhavyaM
Helper V
Helper V

Dynamic datetime parameter using table

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 

BhavyaM_0-1689833221577.pngBhavyaM_1-1689833248164.png

 

BhavyaM_2-1689833327110.png

 

 

1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

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.

View solution in original post

11 REPLIES 11
Syndicate_Admin
Administrator
Administrator

It works fine when I test something similar on my machine, so I'm not sure what's going wrong.

AlexisOlson_0-1692718006083.png

What exactly did you put in the formula bar?

Syndicate_Admin
Administrator
Administrator

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

BhavyaM
Helper V
Helper V

Can anyone please help

 

Hi  @AlexisOlson

 

Please help

 

Thanks in advance'

pankaj_lp
Helper I
Helper I

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

 

pankaj_lp
Helper I
Helper I

can you share the file excluding the non sensitive data

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.