The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hi Community,
Please can you assist i am trying to subtract two dates from two different tables which have a many to one relationship
I have tried using RELATE but i think cause of the one to many relation that does not work
basically trying to subtract the min date for each account by all the dates for that account to get the days
days
thanks in advance
-- If you have a 1:many rel between -- min_date and requests, then this -- will work [Days Since First Date] = -- calculated column in requests var __thisDate = requests[Created Time] var __firstDate = RELATED( min_date[First Date] ) return __thisDate - __firstDate
Please note that such calculations should be performed in Power Query, not in DAX.
Best
Darek
User | Count |
---|---|
37 | |
36 | |
30 | |
29 | |
21 |
User | Count |
---|---|
64 | |
40 | |
32 | |
18 | |
16 |