Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I all,
I have this situation here where I want to get only one time the date that is multiplied in my column just like this :
There are amounts that follows the date and I only want a single time, for instance, 12/20/2017 so I can easely do a sum of those amounts in my dashboard. Can someone help me please. Thanks
Solved! Go to Solution.
Hi @alexcollin24,
You can create a calculated table using SUMMARIZE function:
New Table= SUMMARIZE(TableName,TableName[DateKey],"Sum Amounts",Sum(TableName[Amount]))
Best regards,
Yuliana Gu
Hi @alexcollin24,
You can create a calculated table using SUMMARIZE function:
New Table= SUMMARIZE(TableName,TableName[DateKey],"Sum Amounts",Sum(TableName[Amount]))
Best regards,
Yuliana Gu
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |