Forum Discussion
DATEDIFF across multiple tables
Hello, I am stuggling with the following situation, any advice would be highly appreciated. I have 4 Dimension columns in my AS model: - Requisitions [Requisition Date] - Purchase Orders [PO D...
amitchandak thanks for your reply, not sure I understand though.
The dates are present in 4 different dimension tables. Those dimension tables are connected to 1 fact table through ID's (PO ID, Requisition ID, Invoice ID and Payment ID).
I need a DAX calculation that can check if the date in the dimension table is present. If yes, do a datediff on that date. If no, check the next dimension table date and so on.
amitchandak
Super User
Super UserAnonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.