Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have Date1 from table A and Date2 from table B..
i want to calculate measure as DATEDIFF(A[Date1], B[Date2], Days])
FYI Table A and Table B are not related (no relationship exists)
i'm not able to use the above measure.. is there any other way where i can achieve the result as per my scenario
Any help would be appreciable
thanks
Solved! Go to Solution.
Hi @Puneeth,
It seems that if we wnat to calculate the date difference from different tables, there should be a relationship between the tables.
You could create the index column for both of the tables in Query Editor and create the relationship between the tables.
Then you could try the formula below to create the calcualted column.
Column = DATEDIFF('Date1'[Date1],RELATED(Date2[Date2]),DAY)
Best Regards,
Cherry
Hi @Puneeth,
It seems that if we wnat to calculate the date difference from different tables, there should be a relationship between the tables.
You could create the index column for both of the tables in Query Editor and create the relationship between the tables.
Then you could try the formula below to create the calcualted column.
Column = DATEDIFF('Date1'[Date1],RELATED(Date2[Date2]),DAY)
Best Regards,
Cherry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |