Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
Hi Amine,
I added the calculated column to the model
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
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |