Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago
Solved

How to increase the value automatically monthly increase by 1 digit ?

Hi All   I have below expression working fine :- Show Last 24 Month = IF ('Date'[Date] >= EDATE(TODAY(),-25), 1, 0)   But next month i need to change 25 to 26   May i know it there a way to a...
Need Help
  • admin11's avatar
    admin11
    5 years ago

    v-xiaotang 

    Thank you very much . I will try it out soon

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
5 years ago

Hi admin11 

You can create a table, column Month in the table is related to specific number, then switch the specific number according to column Month.

Create the column:

Show Last 24 Month =
VAR _month =
    MONTH ( TODAY () )
VAR _num =
    CALCULATE (
        SELECTEDVALUE ( 'Table'[Value] ),
        FILTER ( 'Table', MONTH ( 'Table'[Month] ) = _month )
    )
RETURN
    IF ( 'Date'[Date] >= EDATE ( TODAY (), _num ), 1, 0 )

result:

See sample file attached bellow.

 

By the way, I don’t understand why you named the DAX column as Show Last 24 Month since you want the data of the past 25,26,27… months, is there anything wrong?

 

Best Regards,

Community Support Team _ Tang

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

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago

v-xiaotang 

Thank you very much . I will try it out soon