Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
Move you logic from the date table to your measures.
Move you logic from the date table to your measures.
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |