Forum Discussion

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
5 years ago

Common IDs between two days

Hi   I have a table with ID and date field.   using calculate table , i have created two dates tables as date1 and date1   In report view i have created two slicers with date1 and date2. Eg: i...
Need Help
rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
5 years ago

Hi ERD - Thanks for your response.

 

I am not expecting the datesbetween functionality using dates to find out the common ID between two dates i have created two date tables seperately.

 

here on 21st Jan we have some IDs right

Like that 22nd Jan also we have some id. 

 

so, in 21st and 22nd Jan need to findout the common IDs.

 

"Common IDs"

 

Hope it gives you information.

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi,  rajendraongole1 

Not very clear.

Perhaps you can try to copy another date column in your fact table, and then associate the two date columns in the fact table with the date fields in the two date tables.

 

Best Regards,
Community Support Team _ Eason