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.
Hello
I have an unpivoted column I want to be summed. I have tried the following:
Amount at recent date = CALCULATE( SUM('Amount'[Value]); FILTER('Amount';'Amount'[ActualStart] = MAX('Amount'[ActualStart])))
However, this does not seem to work. Anyone have any idea why it does not?
I used the same piece of code in another unpivoted column, where the represented values are 1 and 0. However the problem occurs when the values exceeds this.
Solved! Go to Solution.
I found the problem, quite simple in fact :
Select column -> modeling -> Data type. Then you can choose it yourself.
Hi @BiBra,
You created a calculated column, right? The syntax of your DAX formula is right. In your sample table, what's the data type of 'Amount'[ActualStart]? Could you please share your sample table for further analysis?
Best Regards,
Angelia
I found the problem, quite simple in fact :
Select column -> modeling -> Data type. Then you can choose it yourself.
FYI I get the error message, saying it saves as string
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 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |