Forum Discussion

Rob12's avatar
Rob12
Regular Visitor
4 years ago

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:$...
Need Help DAX
tamerj1's avatar
tamerj1
Community Champion
4 years ago

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

Rob12's avatar
Rob12
Regular Visitor
4 years ago

Hi tamerj1,

it is about outputting the posting date of the work center which is before the "MXX..." work center.
See column "J".

"MXX" is a substring of the workstation which is always the same. However, the previous work center is not always the same. The date of the previous workstation is to be output, however, because this date is to be compared afterwards.
At the end, two dates are compared in order to trace a date fidelity.

 

you can find the table via the following link:

 

https://docs.google.com/spreadsheets/d/1PMVDsx0ZqIvp6gQklat6WNpxDTPzr5hi/edit?usp=sharing&ouid=102559879804136084894&rtpof=true&sd=true

 

I hope its working 🙂