Power BI Measure

[halsa_88]

Hello everyone,

Below is the formula of Tableau , what will be the fomula of this measure in Power Bi?

LOOKUP(SUM({fixed  [Price Deck Date],[ID], [Product]:sum([Yield Value])}),0) - LOOKUP(ZN(SUM({fixed  [Price Deck Date],[ID], [Product]:sum([Yield Value])}))

[v-easonf-msft]

Hi,  @halsa_88 

Many functions in teableau are similar to those in powerbi, but there are also many that cannot be equivalently replaced. For example, fixed can be directly replaced by the allexcept  in powerbi, but lookup can not find the corresponding function in powerbi for direct replacement.

Please  kindly share you sample data and expected output which will better help us understand your problem.

Best Regards,
Community Support Team _ Eason