Unable to use Excel Formula in Powerbi

[ahmer_malick]

The first part is constant with the start date and the other part depend on the run rates of the first part when completed.
Sat/Sun to be considered an off day . If sku run rate isn't there then use machine run rate

[v-vpabbu]

Hi @ahmer_malick,

Thanks @Rupak_bi for Addressing the issue.

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[ahmer_malick]

no it didn't work

[Rupak_bi]

hi @ahmer_malick ,

use "lookupvalue" in powerbi DAX to get the same output as excel XLOOKUP alongwith if statement.