Forum Discussion
Dax Measure help
DateDimensionID JobCloseDate PolicyNumber BranchID Job 20160701 7/1/2016 0:00 A 1 Submission 20160702 7/2/2016 0:00 A 3 Policy Change 20160702 7/3/2016 1:00 C 4 Reinstatem...
Hi vickyprudhvi. What I provided above will work for using with a card without further modification:
What I'm not sure of is why selecting 7/4/2016 would result in 1 with the data provided. The only Policy on that date is A, with a Job of Reinstatement.
Hi KGrice
The table is Type 2 fact so only delta's and new Policies will be added. so as of 07/04/2016 it should consider all the claims whose max jobclosedate has Job type cancellation.