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.
I have added a new column to a table with the following formula:
Stages Progressed Last 30D Raw = if('Contact Progress Log'[Log_Date__c] >= TODAY()-30, ('Contact Progress Log'[Status] - 'Contact Progress Log'[Previous Status])/( 7 - 'Contact Progress Log'[Previous Status]))
It works fine on a row by row basis in the table. But when I try to show it in a Matrix, aggregated by a dimension, I get NaN. I tried creating a measure that averraged the results, but I still get NaN. What am I doing wrong?
Both of those are numeric fields.
Are they both Integer? Double?
They are both calculated columns. The calculations are the same for both, with the exception of the column they access:
Previous Status = VALUE(LEFT('Contact Progress Log'[Previous_Status__c], 1))
Hello @WelterM,
What is the data type for 'Contact Progress Log'[Status] and 'Contact Progress Log'[Previous Status]?
Ramy
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 |
---|---|
106 | |
98 | |
80 | |
67 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |