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.
Hi all,
I need to create some custom columns and was wondering if someone can help with how to handle dates with null value
my custom column is calculating the difference of days between two dates, how can i in the expression translate null to blank (no value) as it will impact my other custom columns
i tried to find if statement but power query didn't seem to find it .....
Solved! Go to Solution.
Hi, that was a mistake
but how do i remove the null and just leave the row blank?
I will create another Conditional column that will state if VSU Days <= 35 days then 1 else 0
and the null value will create an error
@jalaomar ,Instead NULL() you should enter in else part as double quotes like " ". So it will create blank value.
@jalaomar ,Instead NULL() you should enter in else part as double quotes like " ". So it will create blank value.
Thanks! that solved my issue
Hi @jalaomar ,
Reading your concern, I am h aving no idea why ITG3 is having a box though it is not on the formula.
You can do like
if [#"ITG4#(lf)Actual"] = null
or [#"IMS3.1#(lf)Actual"] = null
then null
else
Duration.Days([#"ITG4#(lf)Actual"] - [#"IMS3.1#(lf)Actual"])
Hi, that was a mistake
but how do i remove the null and just leave the row blank?
I will create another Conditional column that will state if VSU Days <= 35 days then 1 else 0
and the null value will create an error
Hi @jalaomar ,
In that case, you can do two options:
first is
if [VSU Days] = null
then 0
else
if [VSU Days] <= 35
then 1
else
0
the second is
try
if [VSU Days] <= 35
then 1
else
0
otherwise
0
Basically the formula is turning your null to 0 instead of creating error
Hope this helps
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |