topic Re: Unable to use Excel Formula in Powerbi in DAX Commands and Tips

Unable to use Excel Formula in Powerbi

ahmer_malick — Fri, 21 Mar 2025 14:35:45 GMT

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

Re: Unable to use Excel Formula in Powerbi

Rupak_bi — Sat, 22 Mar 2025 09:18:06 GMT

hi ahmer_malick ,

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

Re: Unable to use Excel Formula in Powerbi

Anonymous — Wed, 16 Apr 2025 12:31:56 GMT

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

Re: Unable to use Excel Formula in Powerbi

ahmer_malick — Wed, 16 Apr 2025 12:54:22 GMT

no it didn't work

Re: Unable to use Excel Formula in Powerbi

Anonymous — Wed, 23 Apr 2025 10:25:53 GMT

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

Re: Unable to use Excel Formula in Powerbi

Anonymous — Mon, 05 May 2025 12:41:01 GMT

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

Re: Unable to use Excel Formula in Powerbi

Anonymous — Thu, 08 May 2025 10:24:04 GMT

Hi @ahmer_malick,

May I ask if you have gotten this issue resolved?

Regards,
Vinay Pabbu