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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
107 | |
106 | |
91 | |
67 |
User | Count |
---|---|
162 | |
133 | |
132 | |
93 | |
91 |