Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hallo Zusammen,
ich habe folgendes Measure und benötige die Tabellenspalte jedoch bereits im Power Query.
Wie muss ich die Formel in Power Query M richtig schreiben?
Maklervertrag =
IF (
ISBLANK ( KUNDEN[Maklervertrag ab] ),
"Nein",
IF (
ISBLANK ( KUNDEN[Maklervertrag bis] )
|| KUNDEN[Maklervertrag bis] > TODAY (),
"Ja",
"NEIN"
)
)
Beste Grüße
Jörg
Solved! Go to Solution.
Hi @RedTiger80 ,
Probiere gerne das hier in einer "Custom Column":
if [Maklervertrag ab] = null then "nein" else if [Maklervertrag bis] = null or [Maklervertrag bis] > Date.From(DateTime.LocalNow()) then "ja" else "nein"
Gib Bescheid ob es das fuer dich tut 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Hi @RedTiger80 ,
Probiere gerne das hier in einer "Custom Column":
if [Maklervertrag ab] = null then "nein" else if [Maklervertrag bis] = null or [Maklervertrag bis] > Date.From(DateTime.LocalNow()) then "ja" else "nein"
Gib Bescheid ob es das fuer dich tut 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Funktioniert einwandfrei! Vielen Dank!