Creating one dimensions from two different dimensions having values

[Riya07]

Hi,

I have two dimensions

Dim 1
YTD

Dim 2
31-Mar-2021
30-Jun-2021
30-Sep-2021
31-Dec-2021

I want to combine both the dimensions into one single dimension to show it in my filter condition in my app

Dim 3
31-Mar-2021
30-Jun-2021
30-Sep-2021
31-Dec-2021
YTD
Was hoping if anyone can help me with this?

[Digvijay_Singh]

Not sure what exactly you need, what if you concat Dim1 and Dim2 tables in the script? 

[Riya07]

Hi Digvijay,

I wanted the dimension Dim3 to have values from both Dim1 and Dim2. In the filter drop down menu we would have another value of YTD apart from the quarter dates. 

[Digvijay_Singh]

Did u try concatenating YTD in the script like below, but I am not sure how you are going to use this filter pane, you might need to check in you chart expression the selected value in this filter pane to understand what it needs to show -

Dim1:
Load * inline [
Dim
YTD
];

Concatenate(Dim1)
Load * inline [
Dim
31-Mar-2021
30-Jun-2021
30-Sep-2021
31-Dec-2021
];