Forum Discussion

vickyprudhvi's avatar
vickyprudhvi
Helper IV
10 years ago

Dax Measure

DateDimensionID JobCloseDate PolicyNumber TermNumber BranchID Job MostRecentModel 1 7/1/2016 0:00 A 1 1 Submission 1 2 7/2/2016 0:00 A 1 2 Policy Change 1 2 7/2/2016 0:...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

Hi vickyprudhvi,

 

In your scenario,  I would suggest you create a calculated column which returns Previous Job type for each row, then decide whether it's Reinstatement. See:

 

PreviousJob = LOOKUPVALUE(Sheet1[Job],Sheet1[BranchID],Sheet1[BranchID]-1,Sheet1[PolicyNumber],"A")

 

CountPolices = IF(Sheet1[PreviousJob]="Reinstatement",1,0)

 

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu