Forum Discussion
learner03
Post Partisan
Post PartisanFilter from two columns from different Table
I have a Calender Table which I use to calculate Previous Day. I need to calculate Number of Document Numbers that were closed with 48 hours in previous day. For Close within 48 hours, I have creat...
AllisonKennedy
Community Champion
Community Champion
What does your data model look like? If the Calendar table is related to the Order Table on Completed Date (you'll need to extract Date Only so it doesn't have the Time), then you can use a simple measure, for example:
Measure = CALCULATE( COUNT(Order[Document No]) , Calendar[PreviousDay] = "Yes", Order[Completed in 48 Hrs] = "Yes")