Dynamic version

[AlanP514]

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

[amitchandak]

@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]

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

[v-yanjiang-msft · Accepted solution]

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]

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