Forum Discussion
Dynamic Table based on date slicer value
I want to create a calculated table based on the value from a date slicer. E.g. Master table has item wise daily sales (Date,ItemCode,Stock) There is a date slicer (between) to select the per...
Values in a calculated table are fixed. But you may create measures as follows. It takes advantage of Show Categories With No Data.
MaxSelectedDate = CALCULATE ( MAX ( Table1[Date] ), ALLSELECTED ( Table1 ) )
Measure =
VAR d =
MAX ( Table1[Date] )
RETURN
IF ( d = [MaxSelectedDate], SUM ( Table1[Stock] ) )
Measure = VAR d = MAX ( Table1[Date] ) RETURN IF ( d = [MaxSelectedDate], SUM ( Table1[Stock] ) )Hi is there anyway i can sneak in a group by in the above. So i can get the values item wise.
