Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ubaddala
Frequent Visitor

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):

ubaddala_3-1665174825424.png

"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.

ubaddala_2-1665174558131.png

Sample data is:

IDSTATUSDATE_OPENEDDATE_CLOSED
C1OPEN01/01/2010 
C2CLOSED09/01/201212/31/2021
C3CLOSED10/01/201410/06/2016
C4CLOSED10/01/201510/01/2020
C5OPEN02/01/2017 
C6OPEN10/01/2020 

 

Any help is appreciated.

 

Thanks in advance,

Uday

3 REPLIES 3
ubaddala
Frequent Visitor

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
Frequent Visitor

Hi Amine,

I added the calculated column to the model

aj1973
Community Champion
Community Champion

Hi @ubaddala 

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

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.