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 ?
User | Count |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |