Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?!
Would be great if you can share some sample data or app along with expected output to get more details about the problem context