Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys,
I have dates in the format of dd-mmm-yy(01-Apr-17), is it possible to convert it to dd-mmm-yyyy(01-Apr-2017) ?
Thanks
Ajin
Hi Guys,
Both the methods mentioned here involves adding a new column. The reports that I'm working with have huge data, hence I think adding new columns for all date fields might cause performance issues , therefore is there any alternative method of directly changing the column format without adding a new column ?
Hi @ajin,
Based on my research, I am afraid you could not modify the row data in Power BI, I still suggest you to use the Format function to achieve your result.
Regards,
Daniel He
Hi @ajin,
You could refer to below link:
https://msdn.microsoft.com/en-us/query-bi/dax/format-function-dax
https://msdn.microsoft.com/query-bi/dax/custom-date-and-time-formats-for-the-format-function
Regards,
Daniel He
You can use "Add Column from Examples" option to enter the format you require in one or two records. It will detect automatically the required expected format and will populate for all other rows as well. Then replace the old column with new column.
Proud to be a PBI Community Champion
Pat,
This approach is useful, but since my data is large is there a way to do this without adding a new column and changing the existing column( such as how we change the format through modelling)as this might cause performance issues. Plus since this is a date field i would prefer it to remain the same as there are dependencies based on this column.
Thanks
Aj
Hi @ajin,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
Hi @ajin,
Based on my research, I am afraid you could not achieve this feature currently, I suggest you submit an idea in Ideas forum. You may submit a feature request on idea.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Regards,
Daniel He
That's cleaner than my solution since you can delete the old column.
Use a DAX formula to create a new column:
FORMAT('date'[Date],"dd-mmm-yyyy")
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |