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.
Hello i have a month text come from sharepoint list so i need to convert it to date. I tried to convert it using DAX but im still having issues with the relationship i guess because my other 2 tables have date datatype while i just convert this table's month text to date.
Hi,
Use below code to create the datecolumn :
Appreciate your Kudos and please mark it as a solution if it helps
Hi @xRTP ,
You could use datevalue function for this .
For example Date =DATEVALUE([Year] + "/" + [Month] + "/" + 01) or similiar.
Thanks ,
Pratyasha Samal
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
Proud to be a Super User!
I dont have a year only month that was on text form
hi @xRTP ,
You could simple use a static value in place of year or you can make it dynamic by using TODAY() function
For Example :-
Date =DATEVALUE(YEAR(TODAY())+ "/" + [Month] + "/" + 01) or similiar.
Date =DATEVALUE(YEAR("January 2023")+ "/" + [Month] + "/" + 01)
Thanks ,
Pratyasha Samal
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
Proud to be a Super User!
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |