Forum Discussion

StuartSmith's avatar
StuartSmith
Power Participant
3 years ago

First and Last date Calculated Columns based on Date Slicer

Is there a way to have 2 calculated columns called "First Date" & Last Date" populated by a date slicer selection?  The Slicer would have a date hiraracy of Month, Quarter & Year, so there would always be 2 dates to populate the columns.  So if someone selected Jan 2023, the First Date Column would be 01/01/2023 & the Last Date column would be 31/01/2023.  The table with the calculated does not have a relationship with a date table.

 

I have a measure (First Period Date = FIRSTDATE('Table: Dates'[Date]) +0) working, but ideally I want a table column, but when I try thre measure as a column I get the Circular Dependancy error.

 

Can anyone help/advise. Thanks

1 Reply

  • Share some data to work with (in a format the can be pasted in an MS Excel file) and show the expected result.