Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |