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

     

     

kirkademidov's avatar
kirkademidov
Frequent Visitor
8 years ago

Thanks a lot! 

 

This is exactly that I need! 

 

 

 

McCow's avatar
McCow
Resolver III
8 years ago

With pleasure. Enjoy!