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.