Forum Discussion
Solved
FIscal Year Display in Table
Hello all, apologies, I am new to Power BI and I would really appreciate your help. I am having an issue with the display of fiscal date in the table. I am using DAX below to create the Fiscal Year c...
This part : LY & "-" & CY is going to be "2 chars - 4 chars" so that's what needs to be fixed.
--
Also RIGHT should work on a text value but YEAR is going to return a number. This may work but I would not rely on it.
This part : LY & "-" & CY is going to be "2 chars - 4 chars" so that's what needs to be fixed.
--
Also RIGHT should work on a text value but YEAR is going to return a number. This may work but I would not rely on it.
Thank you HotChilli - that works perfectly. I appreciate your quick response. Cheers