Forum Discussion
Date
Hi Anonymous ,
Please try below steps:
1. below is my test table
Table:
2. add a new column with below dax formula
Agjust Year = VAR _val = INT ( "20" & [Year] ) RETURN DATE ( _val, 1, 1 )3. set the format in Power BI Desktop
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.It is working. Thank you very much
Hi Anonymous ,
Please try below steps:
1. below is my test table
Table:
2. add a new column with below dax formula
Agjust Year =
VAR _val = INT ( "20" & [Year] ) RETURN DATE ( _val, 1, 1 )
3. set the format in Power BI Desktop
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It is working. Thank you very much
Anonymous is there a possibility to have the date with the Month included(i.e MM:JJJJ) or in this format (DD:MM:JJJJ). Thanks in advance