Forum Discussion
Power BI Measure
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])}))
1 Reply
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
