Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
AlanP514
Helper V
Helper V

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

AlanP514_0-1654004808056.png

 



AlanP514_1-1654004824587.png

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

1 ACCEPTED SOLUTION

Hi @AlanP514 ,

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

vkalyjmsft_0-1654242229747.png

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.

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

AlanP514_0-1654009909748.png

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

Hi @AlanP514 ,

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

vkalyjmsft_0-1654242229747.png

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.

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.