Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
139 | |
104 | |
104 | |
80 | |
66 |