Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm trying to add the Estimated Customer Locations column if the Da Complete Date is not null.
This is what I'm using, but getting no results.
Estimated Customer Locations | DA Date | DA Complete Date |
350 | 02202021 | 06202021 |
255 | 04202021 | |
25 | 03202021 | 07012021 |
Solved! Go to Solution.
Hi @priley9406 ,
Don't know if this is a measure or a calculate column however the word "null" will not work on this because this is dax and that is not recognized.
What you should use instead of "null" is the BLANK() or the "".
In this case you should redo your measure to:
Completed Locations =
SUMX (
'2022 IFP Build',
IF (
CALCULATE (
SUM ( '2022 IFP Build'[Estimated Customer Locations] ),
'2022 IFP Build'[DA Complete Date] <> BLANK ()
) > 0,
IF ( '2022 IFP Build'[DA Complete Date] = BLANK (), 0 )
)
)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi, @priley9406 ;
You could modify the measure as follows:
Completed Locations =
SUMX (
'2022 IFP Build',
IF (
CALCULATE (
SUM ( '2022 IFP Build'[Estimated Customer Locations] ),
'2022 IFP Build'[DA Complete Date] <> BLANK()
) > 0,
SUM([Estimated Customer Locations]),0
)
)
Or
Completed Locations2 = IF(MAX([DA Complete Date])=BLANK(),0,MAX([Estimated Customer Locations]))
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @priley9406 ,
Don't know if this is a measure or a calculate column however the word "null" will not work on this because this is dax and that is not recognized.
What you should use instead of "null" is the BLANK() or the "".
In this case you should redo your measure to:
Completed Locations =
SUMX (
'2022 IFP Build',
IF (
CALCULATE (
SUM ( '2022 IFP Build'[Estimated Customer Locations] ),
'2022 IFP Build'[DA Complete Date] <> BLANK ()
) > 0,
IF ( '2022 IFP Build'[DA Complete Date] = BLANK (), 0 )
)
)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |