Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have two tables associated via Datamanager.
I want to sum up a value with following condition:
sum({1<Month1={"$(=Num(Month(Today())))"},Year1={"$(=year(Today()))"}>}[Sales])
I want to add one more condition: only where its Null()
So I tried this:
sum({1<Month1={"$(=Num(Month(Today())))"},Year1={"$(=year(Today()))"},ProfitNO={"Null()"}>}[Sales])
or this:
sum({1<Month1={"$(=Num(Month(Today())))"},Year1={"$(=year(Today()))"},isNull(ProfitNO)}>}[Sales])
I also try to give those fields where its null a new name in the load script so I can make simpler set expression:
is(isnull(ProfitNO), 'NEWNAME', ProfitNO)
But it still shows me all value as "-"
I hope someone has an idea.
Thank you very much in advance.
Best.
Hello @MayilVahanan , @dplr-rn ,
thank you very so far. I tried both not working.
But after I used "nullcount()=0" in a set expression it works out. Can you explain why len(trim)) and isNull not returning the same?
Thank you .
Best.
instead of isnull try len(ProfitNO)=0
Try like below
If(isnull(ProfitNO) or Len(Trim(ProfitNO))=0, 'NEWNAME', ProfitNO) as FieldName
Hello @MayilVahanan , @dplr-rn ,
thank you very so far. I tried both not working.
But after I used "nullcount()=0" in a set expression it works out. Can you explain why len(trim)) and isNull not returning the same?
Thank you .
Best.