Forum Discussion
How to show data from 2 different date columns
Hi,
I am looking to show a table with progression over time.
I have data in 2 seperate columns, first is when the data was initially loaded,
and second is when it was corrected.
Then there is a column for Pass/Fail to show if data is correct/wrong.
Screenshot below
In the Remaining, I would like to have the value of "Grand Total" less any data from "Updated Date",
so in this case would expect
| Initial Load Date | Updated Date | Grand Total | Data With issues | Data without issues | Remaining |
| 05/07/2023 | 95 | 4 | 91 | 4 | |
| 05/07/2023 | 11/07/2023 | 100 | 1 | 4 | 5 |
| 09/09/2023 | 107 | 7 | 4 | ||
| 11/07/2023 | 109 | 2 | 4 |
Sample Data
| C Number | Contact | Handler | Rating | In Link | FLAG | Initial Load Date | Updated Date |
| 1 | 546 | AVC | 1 | Yes | Pass | 05/07/2023 | |
| 2 | 547 | AVC | 2 | Yes | Pass | 05/07/2023 | |
| 44 | 589 | JQK | 6 | Yes | Fail | 05/07/2023 | |
| 30 | 575 | JQK | 33 | No | Fail | 05/07/2023 | 11/07/2023 |
| 31 | 576 | JQK | 1 | Yes | Pass | 05/07/2023 | |
| 32 | 577 | JQK | 2 | Yes | Pass | 05/07/2023 | |
| 33 | 578 | JQK | 3 | Yes | Pass | 05/07/2023 | |
| 34 | 579 | JQK | 1 | Yes | Pass | 05/07/2023 | 11/07/2023 |
| 54 | 599 | POL | 3 | Yes | Pass | 05/07/2023 | 11/07/2023 |
1 Reply
Please reformulate your request. It is not clear what you are trying to achieve. You mention that you want a time graph but your expected outcome is a table.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
