Forum Discussion
Mohan128256
Helper IV
2 years agoProvide Optimized DAX version
Hi Greg_Deckler Can you please help me in Optimizing the below DAX query. when we use the below DAX measure in a table visual , along with same kind of other measures , it is taking more rendering time
can you please provide altenative for this .
To know more about the background of this please refer
https://community.fabric.microsoft.com/t5/Desktop/Need-help-to-optimize-DAX-query/m-p/3220292
Final Status =
VAR _MinDate =
CALCULATETABLE(
ADDCOLUMNS(
SUMMARIZE(
'Sales Orders Snapshots',
'Sales Orders Snapshots'[Sales Order ID (H)],
'Sales Orders Snapshots'[Product ID (L)]
),
"@SnapDate", MIN( 'Sales Orders Snapshots'[SnapDate] )
),
ALLSELECTED()
)
VAR _FilterSnap =
TREATAS(
_MinDate,
'Sales Orders Snapshots'[Sales Order ID (H)],
'Sales Orders Snapshots'[Product ID (L)],
'Sales Orders Snapshots'[SnapDate]
)
VAR _Result =
CALCULATE(
MAX( 'Sales Orders Snapshots'[Sales Order Status Name (H)] ),
ALLEXCEPT(
'Sales Orders Snapshots',
'Sales Orders Snapshots'[Sales Order ID (H)],
'Sales Orders Snapshots'[Product ID (L)]
),
KEEPFILTERS( _FilterSnap )
)
RETURN _Result
1 Reply
- Greg_Deckler
Community Champion
Mohan128256 If I understand the ask, this looks like a simple Lookup Min/Max. Lookup Min/Max - Microsoft Fabric Community
See attached PBIX below signature.