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.
Hi Guys,
I'm trying to change my Date format from 31-12-2020 to 12/31/2020 but when I'm using the below formula it is converting to 12-31-2020 instead of 12/31/2020. Kindly help me with this because I need the format to be like MM/DD/YYYY.
FOrmula Used:
Regards,
Himanshu
Solved! Go to Solution.
@Anonymous , check the new column is of text type. because if it is date type. then you need to change the format under column tools
also try like
Received Date Format = FORMAT(View_CashReceipt_Summary[ReceivedDate],"MM/DD/YYYY")
also make sure ReceivedDate is of date type
@Anonymous , check the new column is of text type. because if it is date type. then you need to change the format under column tools
also try like
Received Date Format = FORMAT(View_CashReceipt_Summary[ReceivedDate],"MM/DD/YYYY")
also make sure ReceivedDate is of date type
@Amit I've already tried these things but its still not working.
Data type for ReceivedDate is also Date still not getting formatted like 12\31\2020. Not able to understand what is wrong here.
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 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |