How do I restrict a newly defined date column based one the entire column of the table

shea — Mon, 14 Aug 2023 21:46:34 GMT

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?!

Re: How do I restrict a newly defined date column based one the entire column of the table

Digvijay_Singh — Mon, 14 Aug 2023 23:28:25 GMT

Would be great if you can share some sample data or app along with expected output to get more details about the problem context

topic How do I restrict a newly defined date column based one the entire column of the table in App Development

How do I restrict a newly defined date column based one the entire column of the table

Re: How do I restrict a newly defined date column based one the entire column of the table