Forum Discussion

kirkademidov's avatar
kirkademidov
Frequent Visitor
8 years ago
Solved

To show data by max date range value on slicer

Good day!    I have this kind of data       And I have this kind on Report        I need to show on Current Users Card  values from table - relatively to max date chosen on date s...
Need Help
  • McCow's avatar
    McCow
    8 years ago

    Hi kirkademidov,

    with your PBIX it's OK.

    You need just one more measure, like this:

    Last_Quantity = AVERAGEX(
	CALCULATETABLE(
		TOPN(1;'stg StgFactUsers';'stg StgFactUsers'[PkDateKey];DESC)
	);'stg StgFactUsers'[Quantity]
)//AVG

    And I changed a little your PBIX, so you can look on all my changes HERE:

     

    Best regs

     

     

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi kirkademidov,

 

Can you share a dummy sample please? I can't see any connections between the data and the visualizations. You measure could be like this:

No UID =
CALCULATE (
    MAX ( 'table'[uid] ),
    FILTER ( ALL ( 'datetable' ), 'datetable'[date] = MAX ( 'datetable'[date] ) )
)

Best Regards,

Dale