Forum Discussion
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
- AhmedxSuper User
Share some data to work with (in a format the can be pasted in an MS Excel file) and show the expected result.