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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

if a date is between 2 dates

Hello. 

I have the following problem:

 

2 tables:

- "Dates": a date table with 3 columns: Date (calendar dates); inferiordate (calendar date - 2 days + 16h); superiordate (calendar date - 1 day + 15h59);

correcteddate: (

if weekday of superiordate = saturday; adds 3 days to superiordate; 

if weekday of superiordate = sunday; adds 2 days to superiordate; 

if weekday of superiordate = monday; adds 1 days to superiordate; 

if weekday of superiordate = friday; adds 3 days to superiordate; 

else; adds 1 days to superiordate; 

 

This means that the correctedate will have duplicate dates. 

 

Then, I have other table with production data and with "End of assignment" timestamp.

 

I want to do the following: 

 

If [end of assignment] is between inferiordate and superiordate, assume correcteddate. 

 

The problem is that I can't create relationships between the tables because I have repeteated dates. 

 

Any help?

 

Thanks.

1 ACCEPTED SOLUTION
JW_van_Holst
Resolver IV
Resolver IV

Move you logic from the date table to your measures.

View solution in original post

1 REPLY 1
JW_van_Holst
Resolver IV
Resolver IV

Move you logic from the date table to your measures.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors