Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Filter active records at a specific date

 Hello!   So the problem is: I have a classic dataset with datewarehouse historization; each record has a validFrom, validTo and an isActive flag. I want to see the records in a table, that was ac...
rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hello Anonymous,

 

Let me know if this formula worked or not.

 

Regards.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

rajulshah

 

Hello!

Unfortunatley it does not work.

I created a sample dataset, under this link. This is used in Azure SQL db, with DirectQuery.

 

 

Hope this is help.

 

Thanks,

Matt