Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Well,
If there is a "sale date" recorded for each Lead, I want the value '1' to be returned. If the sales date record does not exist, I want the value '0' to be returned.
I tried it with the following function:
Negócio Fechado =
IF(
ISBLANK('hs_date_entered_13864390')
"1";
"0"
)
...but it's does not work. Well, maybe it's because of the "if" doesn't accept 'date'?
Are there any date functions I could use to check if the date stamp exists and return "1" to me? Help me!!!!!!!!!!!!
And please use correct data types for whatever you do. "1" is a string, not a number.
And here's an excerpt from the above dax.guide with some very important and relavant to your case information:
User | Count |
---|---|
57 | |
21 | |
18 | |
16 | |
16 |
User | Count |
---|---|
87 | |
77 | |
52 | |
37 | |
21 |