Forum Discussion
Power BI Table Visual using SSAS live connection
We are using SSAS model (live connection) to render the reports based on the model shown (other conforming dimensions are not shown here):
"002 Case Activity Date Table" is a date table with all the dates up until today.
The need is to have a date slicer on "002 Case Activity Date Table" and show the table visual in the PBI report satisfying the below conditions:
Show cases/records that have a DATE_OPENED less than or during the period selected and that have DATE_CLOSED greater than during period selected period
I created a calculated column 'ACTIVITY_DATE' in "001 EMS Base" as below: (not sure if this the right approach or not) and it doesn't work.
Sample data is:
| ID | STATUS | DATE_OPENED | DATE_CLOSED |
| C1 | OPEN | 01/01/2010 | |
| C2 | CLOSED | 09/01/2012 | 12/31/2021 |
| C3 | CLOSED | 10/01/2014 | 10/06/2016 |
| C4 | CLOSED | 10/01/2015 | 10/01/2020 |
| C5 | OPEN | 02/01/2017 | |
| C6 | OPEN | 10/01/2020 |
Any help is appreciated.
Thanks in advance,
Uday
3 Replies
Hi Amine,
I added the calculated column to the model
Fine. Let's forget the calculated column.
How can I :
Have a date slicer and show the table visual in the PBI report satisfying the below conditions:
Show cases/records that have a DATE_OPENED less than or during the period selected and those that have DATE_CLOSED greater than during period selected period
