Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am using the code below to try and work out the financial year, and for the output to be YY/YY. It appears to be doing that but upon closer inspection, the actual year output is incorrect in some instances and I can't understand why.
For surv_apps[surv_date] I have, as an example, 31/01/2020 which should have a financial year 19/20 but the output is 20/21. I have tried to pay around with the +1 and -1 but can't get it to output the correct FY.
Can anyone tell me please what it is that I need to amend?
SWITCH ( TRUE (), ISBLANK ( surv_apps[surv_date] ), BLANK (), surv_apps[surv_start_month_no] = 4 && MONTH ( surv_apps[surv_date] ) >= 4, FORMAT ( surv_apps[surv_date], "YY" ) & "/" & FORMAT ( surv_apps[surv_date], "YY" ) * 1 + 1, surv_apps[surv_start_month_no] = 4,
Hi @M_SBS_6 ,
Please check the post about How to Get Your Question Answered Quickly - Microsoft Power BI Community.
Hi @M_SBS_6 ,
Would I ask you to put your complete Dax code here?
Also, why did you put And in the fourth line, it means that it will be true just for month = 4
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
99 | |
97 | |
73 | |
72 |