To simplify my problem :
In my table (workouts new) 4 fields (2 reals 2 virtuals):
1-[Start] - DateTime - Key
2-[Energy] - Decimal
Virtual :
3-[Day] - Date - Formula : Date([Start])
4-[Total Energy per day] - Decimal - Formula :
SUM(SELECT(Workouts New[Energy],[Day]=[_THISROW].[Day], [Day] <>TODAY()+1 ))
Then I get in [Total Energy per day] the figure I want to display in a chart
X = Day
Y = [Total Energy per day]
I donโt succeed to do that with my single table.
And I donโt succeed either to create and populate a new table with [Day] as key and Total energy
Could somebody help me Pleaaaase ?
You can make a slice with a row filter condition that only selects a single record from one day. Use one of the following in the expression.
Thanks for this, but the problem is that in the slice I will anyway keep the same key and then several record for the same day, right ?
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |