Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to 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 , 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])
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.
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 ?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
123 | |
107 | |
61 | |
55 |