Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
@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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |