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.
I am new to PBI and I am trying to combine two columns into one. I created a calculated column PERIOD which is based on the two original columns: YEAR and MONTH. I am getting this error: Cannot convert value '0/01/' of type Text to type Date. Any ideas?
Solved! Go to Solution.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hi,
Try this calculated column formula
=1*("1/"&[Month]&"/"&[Year])
Format this column as Date.
Hi,
Try this calculated column formula
=1*("1/"&[Month]&"/"&[Year])
Format this column as Date.
Thanks, Ashish. This worked as well. It took me a minute to realize I needed to add the column name in the formula "Period =1*("1/"&[Month]&"/"&[Year])". Pretty slick
You are welcome.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
The DATE + SWITCH fix worked beautifully. Thanks for the quick response and for sending a couple solutions. I am sending you Virtual Kudos
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |