Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi!
I have a problem that seems simple but I just can't seem to solve it.
I'm trying to return Hours to a Calculated Column if Start Date and Date matches as in the example below:
I've tried both CALCULATE and IF but both returns errors:
CALCULATE(SUM([Hours]);[Date] = [Start Date])
IF([Start Date] = [Date];[Hours];"")
Help would be much appreciated!
Marcus
Solved! Go to Solution.
Hi
Can you try this ?
New Column = IF(Table1[Start Date] = table1[Date],[Hours])
Let me know if you see any issues.
Thanks
Raj
@Anonymous
I think the solution by @Anonymous would work. You might be getting the error in your IF statement because you are setting the ELSE condition as "". This will probably cause an error because [Hours] is a number and "" is text. You can either use rajendran's version or you can switch the "" with BLANK()
Hope this helps,
Parker
Hi
Can you try this ?
New Column = IF(Table1[Start Date] = table1[Date],[Hours])
Let me know if you see any issues.
Thanks
Raj
Thanks for the reply but that is basically the same IF-formula that I have been trying and I receive an error.
Does this work for you?
Regards
Marcus
@Anonymous
I think the solution by @Anonymous would work. You might be getting the error in your IF statement because you are setting the ELSE condition as "". This will probably cause an error because [Hours] is a number and "" is text. You can either use rajendran's version or you can switch the "" with BLANK()
Hope this helps,
Parker
@Anonymous did work leaving the last argument blank instead of "".
Thank you @Anonymous for the clarification 🙂
Best regards,
Marcus
@Anonymousexactly what is the error you're getting? I have a feeling you're trying to add this as a measure and not a column...
Proud to be a Super User!
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |