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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
MartinDra
Frequent Visitor

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

MartinDra_0-1689063809430.png

 

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 DateUpdated DateGrand TotalData With issuesData without issuesRemaining
05/07/2023 954914
05/07/202311/07/2023100145
09/09/2023 107 74
11/07/2023 109 24

 

 

Sample Data 

C NumberContact HandlerRatingIn LinkFLAGInitial Load DateUpdated Date
1546AVC1YesPass05/07/2023 
2547AVC2YesPass05/07/2023 
44589JQK6YesFail05/07/2023 
30575JQK33NoFail05/07/202311/07/2023
31576JQK1YesPass05/07/2023 
32577JQK2YesPass05/07/2023 
33578JQK3YesPass05/07/2023 
34579JQK1YesPass05/07/202311/07/2023
54599POL3YesPass05/07/202311/07/2023
1 REPLY 1
lbendlin
Super User
Super User

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-...
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/1447...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.