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 eg
V5-May-2021, V6-June-2021 To V1 Jan-2022, and it goes so every month user will share the new version of data with the same schema.
If the schema is following the same schema I am using the append option. But The problem is after appending every time with a new version I want to change my version static value with a new version name like this

 



so every time I want to change this measure manually with the new version
My requirement is instead of this static method how can I achieve this solution as dynamically
for eg (Instead of writing every time a new version name in this dax if I have another measure that contains an updated version so I can mention that here)
Note. this table has a column (version) and it consists of different versions of the table which appended

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.

4 Replies

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

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