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

[v-vpabbu · Accepted solution]

Hi @ahmer_malick,

Excel-like formulas don’t directly work in Power BI tables, you can approach it using Power Query or DAX depending on your need.

If you can upload or paste a sample of your dataset (Not a Screenshot), I can give you exact M-code or DAX.

Regards,

Vinay Pabbu

[v-vpabbu]

Hi @ahmer_malick,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Vinay Pabbu

[v-vpabbu]

Hi @ahmer_malick,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Vinay Pabbu

[Rupak_bi]

hi @ahmer_malick ,

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