Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
prihana
Helper V
Helper V

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 period to show the daily item wise Stock on a graph. MaxSelectedDate is a measure which gets the last date of the slicer.

 

I want to create a calculated table with data only for the MaxSelectedDate item wise and it should change based on the slider movement. I cant just sum up the stock and show the value. Iwant to show the stock for the selected maxDate.

 

Is is possoble?

4 REPLIES 4
v-chuncz-msft
Community Support
Community Support

@prihana,

 

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] ) )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

@prihana,

 

Use a Table visual instead.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SivaMani
Resident Rockstar
Resident Rockstar

I think the calculated table will not be dynamic.

 

refer here, It might be helpful for you

 

https://community.powerbi.com/t5/Desktop/Creating-a-dynamic-summarized-table-or-calculated-table/td-...

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.