Hi @v-qiuyu-msft, Actually you are talking about something else, let me rephrase may be I wasn't clear enough earlier.
I need to find a solution to use dynamic filtering for a date hierarchy range between reports.
I checked Patrick’s demos here and I was able to get the url constructed as desired inside Power BI itself but since we are using Live Connection to SSAS I can’t change the data category of the URL measure to WebURL hence it doesn’t get parsed correctly when clicked from the report.
My understanding is that this needs to be done on the cube side by adding a new column in our Tabular model but this only works for a single string value which I tried and was successful (marked in green below), but how can I do it for a date range??
PFA samples from the DAX that I created and played around with.
In your scenario, please try to modify the red section to DimDate/Date in ('" & CONCATENATEX(VALUES(DimDate[Date]),DimDate[Date], ', ') & "') then test again. Instead add this formula in SSAS model directly,I would suggest you import SSAS related dimension or measures to Power BI desktop then create a measure/calculated column to test the DAX.
Yes I already added it as a calculated column in my SSAS cube, but it doesn't work and gives an error "This filter can't be used since the corresponding field is invalid" - see attached screenshot below.
Do you know how to check for date between 2 values use the other operators?
By the way the format you provided doesn't seem to be correct (see attached screenshot).