How do I restrict a newly defined date column based one the entire column of the table
I want to create a date range for a weekly reporting. I have a table with a defined set of measures from my table. I created a new column with a calculated field.
New column IS A RANGE OF DATE : Min({<[Last_7_Days]={'1'},[Transaction_Type]={'Points','Redemption'}>} DateKey) & '-' & MAX({<[Last_7_Days]={'1'},[Transaction_Type]={'Points','Redemption'}>}DateKey)
Here, I want to select an entire column but the expression would be too long. Any suggestions?!