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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.