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.
Hi,
I am trying to create a Calculated column to track the difference between two dates from two different columns. The goal is to find when a shipment has been recieved (Final Merger) and when the product has been recieved and put away (Export Worksheet). I am trying to create a calcuated column using an if statement, however i run into the error.
The If statement is created within Export OR Final Merger
1. Wont allow me to select multiple tables in my If Statement. If I select either fields, I wont be able to select the other table.
2. Error - "Cannot Find (Column Name)
Tables
Table | Column | Type |
Final_Merger | First Date | Date |
Export Worksheet | Second Date | Date |
Date Dimension | Date | Date |
References
First Table | Second Table | Column | Relationship |
Final_Merger | Export Worksheet | Receipt ID | Many to Many |
Final Merger | Date Dimension | Date | Many to One |
@Swiftglade
I suggest you avoid creating Many-to-Many relationships. If you can share the formula, it will be clear enough.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @Fowmy ,
Many to Many relationship comment-
I will look into cleansing the data, but we recieve it with values that have duplicates, from Receipt ID to another version of Receipt ID. At the moment, we cannot cleanse it and must have it as Many-Many.
Formula-
We are trying to get the First Date from "Final Merger", and compare the date to Export Worksheet.
So for example, We have "Frist Date, which is June 23. We want to know the when the next workday is,
so we created a column in our Date Table to have the next work day.
We then want to compare if the date the product was received (Second Date) is on time or not on time.
Our goal was to do an Greater than if statement.
Another example below.
IF(Second Date>Next Workday),"Shipment has passed date","Shipment was received on time")
Final Merger | Export Worksheet | |
First | Inventory Stored | Next Workday |
2021-02-10 0:00 | 2021-02-11 0:00 | 2021-02-11 0:00 |
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 |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |