Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please help to create a calculated dimension to restrict the data to only previous month from below data.
ID | Date | value |
377 | 3/17/2020 | 5 |
447 | 4/13/2020 | 5 |
534 | 3/19/2020 | 5 |
259 | 3/12/2020 | 5 |
129 | 4/7/2020 | 5 |
346 | 4/8/2020 | 3 |
342 | 5/26/2020 | 5 |
353 | 5/23/2020 | 5 |
434 | 6/1/2020 | 4 |
Result:
ID | Date | value |
342 | 5/26/2020 | 5 |
353 | 5/23/2020 | 5 |
Thanks in advance.
Do you really want a calculated dimension?
Why not using Set analysis in expression?
I need to have a calculated dimension only, as i have multiple expressions.
Thanks In advance.