Hello all,
I have recently been given the task of transferring Spreadsheet/DB data into POWER BI and unfortunately my DAX skills are weak.
I have a report pulling Audit information from an Oracle table and I have dashboards providing Audit information related to whether a user has read a new version. In the example below 'Open Date' being less than 'Revision Date' indicates the areas of concerns. At the moment the report will show all discrepacies for a user but I only need to see the latest.
I have a Table that contains the following data
Doc No Name Open Date Revision Created Date Read
<tbody>
</tbody><colgroup><col span="3"><col><col><col></colgroup>
What I am trying to achieve is a way to filter the table data to show a unique value for each Name (this being the last "Open Date" and ignoring all earlier dates). I thought I could use the Doc No and Name as a filter and then dispaly the MAX date but so far I have failed miserably.
I have the following set to report if the Open date is less than the version date, indicating that the latest version has not been read.(False).
Read = Audit[Open Date]>=Audit[Revision Created Date].
Apologies for my astounding lack of knowledge but Im trying to self teach at the moment and this is proving tricky.
Any help greatly appreciated.
Dave Stuart
I have recently been given the task of transferring Spreadsheet/DB data into POWER BI and unfortunately my DAX skills are weak.
I have a report pulling Audit information from an Oracle table and I have dashboards providing Audit information related to whether a user has read a new version. In the example below 'Open Date' being less than 'Revision Date' indicates the areas of concerns. At the moment the report will show all discrepacies for a user but I only need to see the latest.
I have a Table that contains the following data
Doc No Name Open Date Revision Created Date Read
Doc No | Name | Open Date | Revision Created Date | Read | |
ABC123 | Jo Bloggs | 01/02/2016 | 06/02/2016 | FALSE | |
ABC123 | Jo Bloggs | 02/02/2016 | 07/03/2016 | FALSE | |
ABC123 | Jo Bloggs | 06/02/2016 | 16/07/2016 | FALSE | |
ABC123 | Jo Bloggs | 01/03/2016 | 07/03/2016 | FALSE | |
ABC123 | Doug Schmo | 01/02/2016 | 07/02/2016 | FALSE | |
ABC123 | Doug Schmo | 04/02/2016 | 16/02/2016 | FALSE | |
ABC123 | Doug Schmo | 24/02/2016 | 06/02/2016 | TRUE |
<tbody>
</tbody><colgroup><col span="3"><col><col><col></colgroup>
What I am trying to achieve is a way to filter the table data to show a unique value for each Name (this being the last "Open Date" and ignoring all earlier dates). I thought I could use the Doc No and Name as a filter and then dispaly the MAX date but so far I have failed miserably.
I have the following set to report if the Open date is less than the version date, indicating that the latest version has not been read.(False).
Read = Audit[Open Date]>=Audit[Revision Created Date].
Apologies for my astounding lack of knowledge but Im trying to self teach at the moment and this is proving tricky.
Any help greatly appreciated.
Dave Stuart
Last edited: