Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 column and when it displays in the table the FY shows as 2019-20 which is what I want for the quarters and Q1 and Q2 are correct, however for Q3 and Q4 the FY is displayed like this 19-2020, which is wrong. I don't know why.
This is the DAX for Fiscal Year:
Solved! Go to Solution.
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