Forum Discussion
Solved
Convert date to Quarter year
Hi, I'm trying to create a date table following the instruction that I found on https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi but I have an incorrect syntax error to create a Qu...
hi, napsebi
I have test it again, It still works well. there is error in it.
And If you could try these two formulae if they could work
Column = IF('Date Table'[Month Number] in {1,2,3},"Qtr 1", IF('Date Table'[Month Number] in {4,5,6},"Qtr 2", IF('Date Table'[Month Number] in {7,8,9},"Qtr 3","Qtr 4")))Column 2 = IF('Date Table'[Month Number]<4,1,IF('Date Table'[Month Number]<7,2,IF('Date Table'[Month Number]<10,3,4)))If still has the issue, please share your sample pbix file for us have a test.
You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
