Power BI Table Visual using SSAS live connection

[ubaddala]

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

[ubaddala]

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

[ubaddala]

Hi Amine,

I added the calculated column to the model

[aj1973]

Hi @ubaddala 

You can't add a calculated column in a Live connection Model.