Recreate Excel Formula in DAX

[Capt.Ragnar]

I have the following formula in excel to create a column which indicates the row belongs to the active contract in the dataset...

=IF([@[EffectiveDate]]=MAX(IF([RootID]=[@[RootID]]&[ContractID]=[@[ContractID]]&[EffectiveDate]<=TODAY(),[@[EffectiveDate]])),1,0)

I'm trying to rewrite it in a way that I can insert it into a calculated column in PowerPivot, but so far no luck.

Any ideas?

 

[scottsen]

Can you paste a sample from your table? i actually speak surprisingly poor native excel...