question

CarinMansfield-2636 avatar image
0 Votes"
CarinMansfield-2636 asked Lz-3068 answered

If the Date logged is greater than 7 then populate "FY" and the Year of the Date Logged.

I am trying to figure out my error in the below query.

If the Date logged is greater than 7 then populate "FY" and the Year of the Date Logged.

Logged FY = IF(MONTH('Case Data'[Date Logged]<7)& "FY",YEAR('Case Data'[Date Logged])& "FY",YEAR('Case Data'[Date Logged])+1)

I would like my result to be
FY2021
FY2020
FY2019

FY - Text
2021 - Year (Date Logged)


Thank you in advance

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Lz-3068 avatar image
0 Votes"
Lz-3068 answered

Hi @CarinMansfield-2636

As I mentioned in your previous case instead of something like "where's my error" try to explain what you expect to achieve

I'm not top clear on what you expect here but based on the above case where you wanted to calc. the Quarters with Fiscal Years starting in July I have assumed the FY you expect is based on that same scenario, in which case the following should do it

 ="FY" & YEAR(EDATE('Case Data'[Date Logged], -6))

If this doesn't do what you want please refer to my 1st point and upload a couple of pictures showing:
- What you have - a few representative rows of your 'Case Data' table
- What you expect - the result by row for the above table

Thanks

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.