Forum Discussion
Converting Excel formula into DAX
Hi guys, how can I translate the following formula in DAX? I am still a beginner and I can not do it. Can someone help me? " =WENNFEHLER(INDEX(H:H;AGGREGAT(15;6;ZEILE($E$2:$E$82)/(LINKS($E$2:$...
Hi Rob12
I wish if I speak German.
how do you want to disply this result? Or you just want to create a new calculated table? I can ses that you have selected the date before the one that includes MXX. Any criteria for that? Can you provide the same sample data as copy/paste? Thank you
The result should then be an extra column in the Power BI report and compared with the following.
Delivery date, statistical delivery date, date of invoice posting, date of goods receipt.
But these four dates are already in another query.
I can't get all the dates from one query because SAP and the interface don't allow it.
I will then link the dates to another query via column "D".
Is this somehow understandable?
Greetings, Rob