Forum Discussion
Convert Year and Quarter into YYQQ using DAX
Hi Anonymous ,
Yes, I quickly tested this in one of my reports that contains a date column. Here are the steps that I did:- Go to table view of the report. The column I used is called "Period" and formatted as a Date value.
- Add a calculated column:
- Enter the code from my previous answer (might be required to change the column name of the Date column, e.g. mine is called Period):
- New columns gets calculated:
Did you do it the same way? At which point did you experience the error (and do you have some screenshots that would help me to better look into this)?
- Go to table view of the report. The column I used is called "Period" and formatted as a Date value.
Hi - Yes, but Power BI query gives me an error that the function FORMAT is not recognized. Also, it does not work as the Measure. Please could you check if this works at your end or I am missing something?
Helper IHi Anonymous ,
Yes, I quickly tested this in one of my reports that contains a date column. Here are the steps that I did:
- Go to table view of the report. The column I used is called "Period" and formatted as a Date value.
- Add a calculated column:
- Enter the code from my previous answer (might be required to change the column name of the Date column, e.g. mine is called Period):
- New columns gets calculated:
Did you do it the same way? At which point did you experience the error (and do you have some screenshots that would help me to better look into this)?