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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.