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.
This seems very simple, but I'm getting errors.
I want to replace a blank values in a date column with today.
That is to have a calculated column as:
no_blanks = IF( ISBLANK( a_table[a_date]) , today() , a_table[a_date])
But then I get the error that:
Thank you.
Solved! Go to Solution.
Hi @Diego-mx,
Actually, if you use the formula as a calculated column, that should be right. I also made a test with your formula, everything works as expected.
Please check if you do create the calculated column with the formula?
In addition, if you still have this error, could you share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
Hi @Diego-mx,
Actually, if you use the formula as a calculated column, that should be right. I also made a test with your formula, everything works as expected.
Please check if you do create the calculated column with the formula?
In addition, if you still have this error, could you share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
Thank you for your help.
I turned out I was doing a calculated column on a wrong table, and therefore got that error.
I still dont know how it came to that, but I'm glad to know It works, and next time I'll bug with more interesting stuff.
Cheers.
Hi @Diego-mx,
I'm glad that you have solved your issue. Only thing that you'll have to notice, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Cherry
If you are doing that as a measure, then you need to wrap your column references with an aggregator like MAX. Or, use the formula you have in a calculated column.
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 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |