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.

amitchandak's avatar
amitchandak
Super User
4 years ago

AlanP514 , If you can give a static number to the version or an incremental number you can have.

 

Assume you have a table with an index (added in power Query) with the version

 

Then you have to measure like

 

measure =

var _max = maxx(filter(allselected(Table), Table[Index])

return

maxx(filter(Table, Table[index] =_max) , Table[version])

  • AlanP514's avatar
    AlanP514
    Post Patron
    4 years ago

    Hai amitchandak 
    So you mentioning that i wanted to create a new table with index column and connect with these tables right ?

  • 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.