Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have a metric calculating the difference between the first and last date in a series of date changes.
Thanks in advance
Solved! Go to Solution.
You can use a SUMX like this:
DeltaTotal =
SUMX ( VALUES ( TableName[Column] ), [Days Close Date Delta] )
Where [Column] is whatever column is the lowest level of granularity in your visual.
Thank you! i had been trying something similar but basing it off of the date field and not the id field. that fixed my issue!
You can use a SUMX like this:
DeltaTotal =
SUMX ( VALUES ( TableName[Column] ), [Days Close Date Delta] )
Where [Column] is whatever column is the lowest level of granularity in your visual.
Thank you! i had been trying something similar but basing it off of the date field and not the id field. that fixed my issue!
User | Count |
---|---|
119 | |
95 | |
87 | |
74 | |
65 |
User | Count |
---|---|
138 | |
112 | |
110 | |
98 | |
94 |