Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
45 | |
18 | |
16 |