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 am trying to use format DAX to convert to a mmm-yy format, but the column with the date is not coming up which is completion time when I try to enter it into DAX formula.
Solved! Go to Solution.
@jcastr02 are you creating a new column or a new measure? So you create completion time in the query editor, you then push it to the visual pane and now you are trying to format that field in DAX but when you create a new column you can't see the date? Are you sure you creating a new column and not a new measure?
Proud to be a Super User!
Select the column and go to "column tools"
Change the Data Type as "Date"
set the Format as mmm-yy
@jcastr02 can you post your code?
Proud to be a Super User!
Proud to be a Super User!
Hi Vijay, This worked great. However it stores the data in the field as TEXT and if I change it to DATE, I get ERROR message. If it's not a DATE, I cannot use it in a trend chart graph?
To get Date information you must have one date column
Without Date column you cant manage any Date Hierarchy
Proud to be a Super User!
@VijayP I have column with date (completion time) see 1st pic above and the format is set to date and time
You are in powerquery editor
Close and apply the power query editor and then
in Report view goto Sheet View and there Add new column
In the new column you can write What i menetioned above.
In power query editor you cannot write DAX
Proud to be a Super User!
@jcastr02 are you creating a new column or a new measure? So you create completion time in the query editor, you then push it to the visual pane and now you are trying to format that field in DAX but when you create a new column you can't see the date? Are you sure you creating a new column and not a new measure?
Proud to be a Super User!
@vanessafvg That was it, I was trying to create a measure vs. a column! Thank you for the help!
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |