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.
Solved! Go to Solution.
I'm not able to replicate the issue and if what you are saying is correct about the original data column then i don't see why it should not work.
What if you try and duplicate the original column and change the format under modeling instead of using a calculated column
This gives you pretty much the same format as you desired
Hi,
It seems it's having trouble converting to a date datatype.
Is it possible you could provide the data for the Pipeline[Award Date] column?
I have gone through the column and found no bad data in this column, my above formula runs perfectly fine if I have the calculated column set as a text datatype. However I need to have it as a date type to sort
Right, so the problem most likely lies then with the calculated column itself.
Probably should have asked this previously as well but could you provide the data for the calculated column when it's in text format
Which is ulimately the format I want it to look like and sort the data by in my Matrix
I'm not able to replicate the issue and if what you are saying is correct about the original data column then i don't see why it should not work.
What if you try and duplicate the original column and change the format under modeling instead of using a calculated column
This gives you pretty much the same format as you desired
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |