Last Date of Timeline Slicer

[zqcebtmu]

Hi,

I'm trying to create a calculated column which calculates hours between a start date and the last date of my timeline slicer. Any ideas? I'm using a date table for my slicer and everytime I try to find the last date, it populates with the last date in the date table without the timeline slicer filter applied. I.e. last date of date table = today and timeline slicer is selected to show September data only. When I call LASTDATE('dates'[date]), I get today's date instead of September 30.

Thank you,

Tim

[v-lili6-msft · Accepted solution]

hi, @zqcebtmu

calculated column and calculate table can't be affected by any slicer. you could create a measure instead of column.

Notice:

1. Calculation column/table not support dynamic changed based on filter or slicer. (So sum(table[column]) will return fixed value)
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.

here is reference:

https://community.powerbi.com/t5/Desktop/Different-between-calculated-column-and-measure-Using-SUM/t...

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

Best Regards,
Lin

Best Regards,
Lin