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.
Dear all,
I have a table like below :
Column 1 | Received Date |
A | 1/1/2020 |
B | 3/2/2020 |
C | 8/2/2020 |
A | 3/1/2020 |
B | 1/3/2020 |
C | 12/12/2020 |
Receiced date is a column in the table and I have a calculate measure called "the last refresh date" - this is usually is system date.
I would like to caclulate the average days between received date and last refresh date for A. (I would like both by calendar days and business days)
Thank you !!
It is 7777 days from the start date to the end date, but not including the end date. Or 21 years, 3 months, 15 days excluding the end date. Or 255 months, 15 days excluding the end date.
You can have measures like these
Diff = datediff(table[Received Date],[last refresh date],DAY)
Avg Diff = AverageX(Summarize(Table, Table[Column 1],"_1",[Diff]),[_1])
Hi @amitchandak Thank you so much for your help! I did send a message yesterday but it not successfully out.
That work for me. But when I create any measure, it all gave ERROR results:
What I would like to do it calculate the average days between referral received date and the next planned call date. The next planned call date is a measure created from another table. Below is my dax function:
This is my next planned sessions measure:
Hi @xiumi_hou ,
Please share me a dummy PBIX file, removing sensitive information, for specific test.
Best Regards,
Icey
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 |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |