Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi All,
I am using Power Bi for the first time and spent weeks trying to understand (Learn small steps) a simple Excel file that I produce ever month, highlighting the differences in three columns.
I take the spreadsheet and combine each of the month Tabs into one sheet with Power Bi and call the first column the Report date.
I then create three reference tables with the report date App_Key (that I made) and pivot the three tables by the Report date this gives me comparison layout. This took me about 6 weeks to get to this stage.
I have two slicers with two separate tables with the Report Date (Table A and Table B)
Table A
Selection Value A = IF(SELECTEDVALUE('Table A'[Report Date])
=SELECTEDVALUE('Table B'[Report Date]),0,1)
Table B
Selection Value B = IF(SELECTEDVALUE('Table B'[Report Date])
=SELECTEDVALUE('Table A'[Report Date]),0,1)
So this bit works on the selection.
My issue is that I want to filter and display the columns from the selection
Measure A Table = VALUES(Data[Report Date]),FILTER(Data,Data[Report Date]=SELECTEDVALUE('Table A'[Report Date]))
But not understanding Dax and I can’t see what is wrong
Hey @V2jtb-Info ,
as always the start is difficult, but it will get easier over time.
Your description is very hard to understand as we all don't know your data model.
Can you create a sample file and share it here? This would make it a lot easier to help you.
Best regards
Denis
Report Date | u business _ application | u business applicationsys updated_on | 1 business applicationsys updated by | u _ business _ applicationbusiness _ criticality | u business _ applicationinternal lifecycle | sys _created_on | sys created _by | sys_ updated_on | sys_updated_by | u _ business _ applicationu_ deployment_mode | service _provider | u type | u_provider | u business applicationit _owner | u _ business applicationu it team | u _ business applicationu bu manager | u _ business _ applicationu system_ownr | u business _ applicationsteward | u _ business _ applicationu_ifc relevance | business applicationu solvency_ ii relevance | 1 business applicationu sensitive _data_y_n | u business applicationu aaa_ tech cloud _broker | u _ business _ applicationcomments |
31-Jan-22 | Wordpad | 10/12/2021 15:20 | Tracy@jtboyle.co.uk | Important | Live | 10/12/2021 15:20 | mail@jtboyle.co.uk | 18/10/2021 00:09 | mail@jtboyle.co.uk | On Premise | Not Supplied | Traditional Infrastructure | ABC | Darcy Soper | Sales Department | John Jennifer | Blake Robinson | Jorge White | Yes | Not Supplied | Not Supplied | TRUE | Not Supplied |
08-Mar-23 | Wordpad | 10/12/2021 15:20 | Tracy@jtboyle.co.uk | Important | Live | 10/12/2021 15:20 | mail@jtboyle.co.uk | 18/10/2021 00:09 | mail@jtboyle.co.uk | On Premise | Not Supplied | Traditional Infrastructure | ABC | Darcy Soper | Sales Department | John Jennifer | Blake Robinson | Jorge White | Yes | Not Supplied | Not Supplied | TRUE | Not Supplied |
05-Apr-23 | Wordpad | 10/12/2021 15:20 | Tracy@jtboyle.co.uk | Important | Live | 10/12/2021 15:20 | mail@jtboyle.co.uk | 18/10/2021 00:09 | mail@jtboyle.co.uk | On Premise | Not Supplied | Traditional Infrastructure | ABC | Darcy Soper | Sales Department | John Jennifer | Blake Robinson | Jorge White | Yes | Not Supplied | Not Supplied | TRUE | Not Supplied |
12-Apr-23 | Wordpad | 10/12/2021 15:20 | Tracy@jtboyle.co.uk | Important | Live | 10/12/2021 15:20 | mail@jtboyle.co.uk | 18/10/2021 00:09 | mail@jtboyle.co.uk | On Premise | Not Supplied | Traditional Infrastructure | ABC | Darcy Soper | Sales Department | John Jennifer | Blake Robinson | Jorge White | Yes | Not Supplied | Not Supplied | TRUE | Not Supplied |
31-Jan-22 | Word | 18/10/2021 00:09 | mail@jtboyle.co.uk | Not Supplied | Proposition | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | 10/12/2021 15:20 | Tracy@jtboyle.co.uk | PaaS | Microsoft | Public PaaS | MS Azure | Tracy White | Human Resource Department | William Barbara | Riley Davis | Roberto Williams | Yes | Yes | Yes | TRUE | Not Supplied |
08-Mar-23 | Word | 18/10/2021 00:09 | mail@jtboyle.co.uk | Not Supplied | Proposition | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | 10/12/2021 15:20 | Tracy@jtboyle.co.uk | PaaS | Microsoft | Public PaaS | MS Azure | Tracy White | Human Resource Department | William Barbara | Riley Davis | Roberto Williams | Yes | Yes | Yes | TRUE | Not Supplied |
05-Apr-23 | Word | 18/10/2021 00:09 | mail@jtboyle.co.uk | Not Supplied | Proposition | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | 10/12/2021 15:20 | Tracy@jtboyle.co.uk | PaaS | Microsoft | Public PaaS | MS Azure | Tracy White | Human Resource Department | William Barbara | Riley Davis | Roberto Williams | Yes | Yes | Yes | TRUE | Not Supplied |
12-Apr-23 | Word | 18/10/2021 00:09 | mail@jtboyle.co.uk | Not Supplied | Proposition | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | 10/12/2021 15:20 | Tracy@jtboyle.co.uk | PaaS | Microsoft | Public PaaS | MS Azure | Tracy White | Human Resource Department | William Barbara | Riley Davis | Roberto Williams | Yes | Yes | Yes | TRUE | Not Supplied |
31-Jan-22 | Windows Movie Maker | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | Important | Live | 18/10/2021 00:09 | mail@jtboyle.co.uk | 10/12/2021 15:20 | mail@jtboyle.co.uk | PaaS | Microsoft | Public PaaS | MS Azure | Darcy Soper | Sales Department | Steven Kimberly | Lewis Martin | Gilbert Walker | No | No | Unkown | TRUE | Not Supplied |
08-Mar-23 | Windows Movie Maker | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | Important | Live | 18/10/2021 00:09 | mail@jtboyle.co.uk | 10/12/2021 15:20 | mail@jtboyle.co.uk | PaaS | Microsoft | Public PaaS | MS Azure | Darcy Soper | Sales Department | Steven Kimberly | Lewis Martin | Gilbert Walker | No | No | Unkown | TRUE | Not Supplied |
05-Apr-23 | Windows Movie Maker | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | Important | Live | 18/10/2021 00:09 | mail@jtboyle.co.uk | 10/12/2021 15:20 | mail@jtboyle.co.uk | PaaS | Microsoft | Public PaaS | MS Azure | Darcy Soper | Sales Department | Steven Kimberly | Lewis Martin | Gilbert Walker | No | No | Unkown | TRUE | Not Supplied |
12-Apr-23 | Windows Movie Maker | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | Important | Live | 18/10/2021 00:09 | mail@jtboyle.co.uk | 10/12/2021 15:20 | mail@jtboyle.co.uk | PaaS | Microsoft | Public PaaS | MS Azure | Darcy Soper | Sales Department | Steven Kimberly | Lewis Martin | Gilbert Walker | No | No | Unkown | TRUE | Not Supplied |
31-Jan-22 | VLC | 10/12/2021 15:20 | mail@jtboyle.co.uk | Mission Critical | Live | 10/12/2021 15:20 | mail@jtboyle.co.uk | 18/10/2021 00:09 | mail@jtboyle.co.uk | laaS | Not Supplied | laaS | Other | John Boyle | Purchase Department | Matthew Betty | Miles King | Jorge White | Not Supplied | Not Supplied | Not Supplied | TRUE | Not Supplied |
08-Mar-23 | VLC | 10/12/2021 15:20 | mail@jtboyle.co.uk | Mission Critical | Live | 10/12/2021 15:20 | mail@jtboyle.co.uk | 18/10/2021 00:09 | mail@jtboyle.co.uk | laaS | Not Supplied | laaS | Other | John Boyle | Purchase Department | Matthew Betty | Miles King | Jorge White | Not Supplied | Not Supplied | Not Supplied | TRUE | Not Supplied |
05-Apr-23 | VLC | 10/12/2021 15:20 | mail@jtboyle.co.uk | Mission Critical | Live | 10/12/2021 15:20 | mail@jtboyle.co.uk | 18/10/2021 00:09 | mail@jtboyle.co.uk | laaS | Not Supplied | laaS | Other | John Boyle | Purchase Department | Matthew Betty | Miles King | Jorge White | Not Supplied | Not Supplied | Not Supplied | TRUE | Not Supplied |
12-Apr-23 | VLC | 10/12/2021 15:20 | mail@jtboyle.co.uk | Mission Critical | Live | 10/12/2021 15:20 | mail@jtboyle.co.uk | 18/10/2021 00:09 | mail@jtboyle.co.uk | laaS | Not Supplied | laaS | Other | John Boyle | Purchase Department | Matthew Betty | Miles King | Jorge White | Not Supplied | Not Supplied | Not Supplied | TRUE | Not Supplied |
31-Jan-22 | Visio | 10/12/2021 15:20 | mail@jtboyle.co.uk | Mission Critical | In Development | 10/12/2021 15:20 | Tracy@jtboyle.co.uk | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | SaaS | Not Supplied | SaaS | FGH | Neels Brown | Finance Department | Michael Linda | Seth Brown | Dan Wilson | Yes | Yes | Yes | TRUE | Not Supplied |
08-Mar-23 | Visio | 10/12/2021 15:20 | mail@jtboyle.co.uk | Mission Critical | In Development | 10/12/2021 15:20 | Tracy@jtboyle.co.uk | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | SaaS | Not Supplied | SaaS | FGH | Neels Brown | Finance Department | Michael Linda | Seth Brown | Dan Wilson | Yes | Yes | Yes | TRUE | Not Supplied |
05-Apr-23 | Visio | 10/12/2021 15:20 | mail@jtboyle.co.uk | Mission Critical | In Development | 10/12/2021 15:20 | Tracy@jtboyle.co.uk | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | SaaS | Not Supplied | SaaS | FGH | Neels Brown | Finance Department | Michael Linda | Seth Brown | Dan Wilson | Yes | Yes | Yes | TRUE | Not Supplied |
12-Apr-23 | Visio | 10/12/2021 15:20 | mail@jtboyle.co.uk | Mission Critical | In Development | 10/12/2021 15:20 | Tracy@jtboyle.co.uk | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | SaaS | Not Supplied | SaaS | FGH | Neels Brown | Finance Department | Michael Linda | Seth Brown | Dan Wilson | Yes | Yes | Yes | TRUE | Not Supplied |
31-Jan-22 | The Applicaion can have duplicate entries | 18/10/2021 00:09 | mail@jtboyle.co.uk | Important | Not Supplied | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | PaaS | Microsoft | Public PaaS | MS Azure | Darcy Soper | Sales Department | David Elizabeth | Ivan Clark | Brian Young | Yes | Yes | Unkown | TRUE | Not Supplied |
08-Mar-23 | The Applicaion can have duplicate entries | 18/10/2021 00:09 | mail@jtboyle.co.uk | Important | Not Supplied | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | PaaS | Microsoft | Public PaaS | MS Azure | Darcy Soper | Sales Department | David Elizabeth | Ivan Clark | Brian Young | Yes | Yes | Unkown | TRUE | Not Supplied |
05-Apr-23 | The Applicaion can have duplicate entries | 18/10/2021 00:09 | mail@jtboyle.co.uk | Important | Not Supplied | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | PaaS | Microsoft | Public PaaS | MS Azure | Darcy Soper | Sales Department | David Elizabeth | Ivan Clark | Brian Young | Yes | Yes | Unkown | TRUE | Not Supplied |
12-Apr-23 | The Applicaion can have duplicate entries | 18/10/2021 00:09 | mail@jtboyle.co.uk | Important | Not Supplied | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | 18/10/2021 00:09 | Tracy@jtboyle.co.uk | PaaS | Microsoft | Public PaaS | MS Azure | Darcy Soper | Sales Department | David Elizabeth | Ivan Clark | Brian Young | Yes | Yes | Unkown | TRUE | Not Supplied |
Column Name | Comment |
App_Key | is concatenation of u business _ application and u type |
Report Date | |
u business _ application | |
u business applications updated_on | |
1 business applicationsys updated by | |
u _ business _ applicationbusiness _ criticality | 1 monitoring for change |
u business _ applicationinternal lifecycle | 2 monitoring for change |
sys _created_on | |
sys created _by | |
sys_ updated_on | |
sys_updated_by | |
u _ business _ applicationu_ deployment_mode | 3 monitoring for change |
service _provider | |
u type | |
u_provider | |
u business applicationit _owner | when a change is fond on 1,2 or 3 |
u _ business applicationu it team | when a change is fond on 1,2 or 3 |
u _ business applicationu bu manager | when a change is fond on 1,2 or 3 |
u _ business _ applicationu system_ownr | when a change is fond on 1,2 or 3 |
u business _ applicationsteward | when a change is fond on 1,2 or 3 |
u _ business _ applicationu_ifc relevance | |
business applicationu solvency_ ii relevance | |
1 business applicationu sensitive _data_y_n | |
u business applicationu aaa_ tech cloud _broker | |
u _ business _ applicationcomments |
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
86 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
110 | |
97 | |
71 | |
67 |