Forum Discussion
Difference bw dates in power BI
The issue lies in the fact that the data is spread across two rows instead of a single row in the account table. This is because the data for both systems has different IDs and applications, resulting in separate rows.
I have separated the data into two tables for Cord (ID 3) and Ping (ID 2266) but since the IDs are different in account table , unable to find a way to combine them into a single row in order to find a difference between tables.
As per the attached screenshot , Is there a way to find the differenc betwen the two login dates 6/7/2024 to 6/6/2024. In database I have 2 million records.
Thanks for the support.
7 Replies
- lbendlinSuper User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to 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.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 - krishnakv83Frequent Visitor
Hi all,
Here is the requirement with sample data. Please have a look and let me know if you need more info.
I have a main table like below and I separated into two tables Table 1 and Table 2 based on the application ID to find the greater date between two tables.
I'm not able to bring user id ( which is available in customer table) to match two tables but facing multiple valuse issues. To bring user to either table1 or table2 facing issue.
=calculate(values(userid))
Requirment:I need to find greater/ latest date between Application 3 and 22 from the table. Regards, Krishna
Table 2 ID APPLICATION_ID LAST_DATE 32741696 22 02-06-2024 00:00 32741708 22 03-06-2024 00:00 32741709 22 07-06-2024 00:00 32741710 22 05-05-2024 00:00 32741694 22 07-06-2024 00:00 32741698 22 05-06-2024 00:00 32741699 22 07-06-2024 00:00 32741701 22 07-06-2024 00:00 32741700 22 07-06-2024 00:00 32741703 22 07-06-2023 00:00 32741704 22 05-06-2024 00:00 32803116 22 01-06-2024 00:00 Table1 ID APPLICATION_ID LAST_DATE 9285 3 07-06-2024 00:00 8855 3 07-06-2024 00:00 9269 3 03-06-2024 00:00 7950 3 07-05-2024 00:00 7718 3 07-06-2024 00:00 12593 3 05-06-2024 00:00 12040 3 07-06-2024 00:00 11819 3 07-06-2024 00:00 11820 3 07-06-2024 00:00 15370 3 07-06-2024 00:00 19197 3 05-06-2024 00:00 19360 3 01-06-2024 00:00 Main Table
ID APPLICATION_ID LAST_DATE 9285 3 07-06-2024 00:00 8855 3 07-06-2024 00:00 9269 3 03-06-2024 00:00 7950 3 07-05-2024 00:00 7718 3 07-06-2024 00:00 12593 3 05-06-2024 00:00 12040 3 07-06-2024 00:00 11819 3 07-06-2024 00:00 11820 3 07-06-2024 00:00 15370 3 07-06-2024 00:00 19197 3 05-06-2024 00:00 19360 3 01-06-2024 00:00 32741696 22 02-06-2024 00:00 32741708 22 03-06-2024 00:00 32741709 22 07-06-2024 00:00 32741710 22 05-05-2024 00:00 32741694 22 07-06-2024 00:00 32741698 22 05-06-2024 00:00 32741699 22 07-06-2024 00:00 32741701 22 07-06-2024 00:00 32741700 22 07-06-2024 00:00 32741703 22 07-06-2023 00:00 32741704 22 05-06-2024 00:00 32803116 22 01-06-2024 00:00 - lbendlinSuper User
How are you planning to correlate between rows? Based on the LAST_DATE column alone?
- krishna_kvNew Member
Hi,
I tried to correlate with related funciton but it doesnot work as the relationship is many to many.
secondly I tried Calculate(values(date)) it shown with error - multiple values retuned where single value was expected.
Please give some inputs here.