Forum Discussion

cristianml's avatar
cristianml
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Create generic Measure or column table for wording FY, Previous FY, etc..

Hi,   I need help to create a measure o column table that can give me a some wording depending of each Fiscal year.    I got the Current FY if this criteria is true:   VAR _MTD = MAX('00_CALEND...
data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, cristianml 

     

    I simply restore your table data by the method shown below.

    Measure:

    Current/Prior FY =
IF (
    SELECTEDVALUE ( 'Date'[Fiscal year] ) = YEAR ( TODAY () ),
    "Current",
    IF (
        SELECTEDVALUE ( 'Date'[Fiscal year] ) < YEAR ( TODAY () ),
        "Prior" & "-"
            & YEAR ( TODAY () ) - SELECTEDVALUE ( 'Date'[Fiscal year] )
    )
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, cristianml 

 

I simply restore your table data by the method shown below.

Measure:

Current/Prior FY =
IF (
    SELECTEDVALUE ( 'Date'[Fiscal year] ) = YEAR ( TODAY () ),
    "Current",
    IF (
        SELECTEDVALUE ( 'Date'[Fiscal year] ) < YEAR ( TODAY () ),
        "Prior" & "-"
            & YEAR ( TODAY () ) - SELECTEDVALUE ( 'Date'[Fiscal year] )
    )
)

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.