Error Power BI - Power Query Editor - Today function

Diskutiere Error Power BI - Power Query Editor - Today function im Office Forum im Bereich Microsoft Community Fragen; Hi guys! Simple Problem: I want to make a function, which Shows if the a date from the column "End" is > = to Todays date or = null then "1" ...
M

MSCom

Neuer Benutzer
Threadstarter
Dabei seit
20.09.2016
Beiträge
1
Hi guys!


Simple Problem: I want to make a function, which Shows if the a date from the column "End" is > = to Todays date or = null then "1" , if not then "0".


I used this function:

if [#"End"] = DateTime.LocalNow or [#"Ende"] > DateTime.LocalNow or [#"Ende"] = null then 1 else 0


but there i always coming an Error in each row stating:

Expression.Error: We cannot apply operator < to types Function and Date.
Details:
Operator=<
Left=[Function]
Right=01.05.2020



I dont know what to do. Can somebody show me exactly what to do? Thanks a lot!


Greta
 
Thema:

Error Power BI - Power Query Editor - Today function

Error Power BI - Power Query Editor - Today function - Ähnliche Themen

Using Vlookup on other Workbook whichs path is stored in a Cell: Good Day Im Trying to do Vlookup on a closed Workbook whichs path is stored in a Cell. For that im writing a Function which opens the Workbook...
Retrieve old data before refreshing database: Hello I have connected my Power BI to SAP server to access data. Every time I refresh the database, the new values appear on the report. What...
Access Database Not Working: Hello, I am trying to work with my Access database and keep getting the following message: The expression On Click you entered as the event...
Strange Excel behavior in some IF functions: Yesterday I was notified about the false calculation results in one of our interface files. After some research I came to the conclusion that the...
Access auf die Datenbank funktioniert nicht - Access Database Not Working: Hallo, Ich versuche, mit meiner Access-Datenbank zu arbeiten und erhalte immer wieder die folgende Meldung: Der Ausdruck On Click, den Sie als...

Sucheingaben

poker tutorial

,

seminole 7casino

,

Lpoker ante

,
desert nights casino
, desert nights 4casino, foxwoods poke(r, casino rewards, [casino rewards, pok/er tutorial, casino gratis, casZino gratis, poker texas holdem, seminole casino, free Npoker practice, free poker practice, pokehr tutorial, poker free online, 9poker free online, harrahs casin*o cherokee, isles casino poker, isles casino pokesr, laughlin cas$ino, lucky lady casino, video pok.er trainer, barona casino
Oben