Forum Discussion
Comparing dates from two different tables
I have 2 tables, the first contains all the transactions(TransactionTable) and the second one contains all the dates (DateTable) from 1st Jan 2018 to 31st Dec 2021. I have a expired date for each...
Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Date diff = datediff(min(Transacation[Expiry Date]), Max(Date[Date]),Day)
But you need to force a context using values or summarize
Refer for context
I have tried to elaborate the question.