Forum Discussion

AlanP514's avatar
AlanP514
Post Patron
4 years ago
Solved

Dynamic version

Hai All, I am expecting a super solution for this requirement. The requirement is  Currently I am working on a sales dashboard and every year this report is having different versions of tables for ...
Need Help
Show and Tell
Tips and Tricks
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi AlanP514 ,

    Not to create a new index table, but to add an index column in the Master table.

    And modify your original formula like this:

    CALCULATE (
    SUM ( 'Sales'[Value] ) / 100,
    'Master'[Version]
        = MAXX (
            FILTER (
                ALL ( 'Master' ),
                'Master'[Index] = MAXX ( ALL ( 'Master' ), 'Master'[Index] )
            ),
            'Master'[Version]
        ),
    ALL ( 'Master'[Comparisions] )
)

    Best Regards,
    Community Support Team _ kalyj

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

AlanP514's avatar
AlanP514
Post Patron
4 years ago

Hai amitchandak 
The Dax is showing error, can you please guide me to rectify this dax

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi AlanP514 ,

Not to create a new index table, but to add an index column in the Master table.

And modify your original formula like this:

CALCULATE (
    SUM ( 'Sales'[Value] ) / 100,
    'Master'[Version]
        = MAXX (
            FILTER (
                ALL ( 'Master' ),
                'Master'[Index] = MAXX ( ALL ( 'Master' ), 'Master'[Index] )
            ),
            'Master'[Version]
        ),
    ALL ( 'Master'[Comparisions] )
)

Best Regards,
Community Support Team _ kalyj

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