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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
The_Clam
Helper I
Helper I

Please help - DATES from two different tables being within 24 hours of each other. Power BI file inc

Hi!  I need to be able to select NAME from Table A if the NAME from Table A = the NAME from Table B AND the DATE from Table A is within 24 hours prior to the DATE from Table B.  Please help.  Power BI file is linked below.  Thanks!

 

https://drive.google.com/file/d/1QhQBqGIGx2dECiZwAZ-Yz9UFcFwY_-Ne/view?usp=sharing

 

1 ACCEPTED SOLUTION
v-rongtiep-msft
Community Support
Community Support

Hi @The_Clam ,

Please refer to my pbix file to see if it helps you.

Create a measure.

Measure = var _1=CALCULATE(MAX('Table B'[Date]),FILTER(ALL('Table B'),'Table B'[Name]=SELECTEDVALUE('Table A'[Name])))
var _2=DATEDIFF(MAX('Table A'[Date]),_1,HOUR)
return 
 IF(MAX('Table A'[Name]) in VALUES('Table B'[Name])&&((_2<=24&&_2>=0)||(_2<=0&&_2>=-24)),1,BLANK())

vpollymsft_0-1675307312395.png

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-rongtiep-msft
Community Support
Community Support

Hi @The_Clam ,

Please refer to my pbix file to see if it helps you.

Create a measure.

Measure = var _1=CALCULATE(MAX('Table B'[Date]),FILTER(ALL('Table B'),'Table B'[Name]=SELECTEDVALUE('Table A'[Name])))
var _2=DATEDIFF(MAX('Table A'[Date]),_1,HOUR)
return 
 IF(MAX('Table A'[Name]) in VALUES('Table B'[Name])&&((_2<=24&&_2>=0)||(_2<=0&&_2>=-24)),1,BLANK())

vpollymsft_0-1675307312395.png

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

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