Forum Discussion
Count values depending on a condition
Hi all, my next question :) I've got a table with dates and available status (1 and 0.5). What I want to achieve is when I plot the values in an area chart I see that on the 4the of janua...
Hi MFelix,
Maybe you can try to use summarize function to create a summary table:
Table = SUMMARIZE(Table1,[Date],"Total Day",SUM(Table1[Avaliable Days]))
Regards,
Xiaoxin Sheng
Hi I can't get it working.
The result that i want is that I can plot this to an area chart where also some kpi's are shown.
Result:
First login Available
4/01/2017 4,5
5/01/2017 8
Hope that you can give me some more advice thanks!
Hi MFelix,
Maybe you can try to use summarize function to create a summary table:
Table = SUMMARIZE(Table1,[Date],"Total Day",SUM(Table1[Avaliable Days]))
Regards,
Xiaoxin Sheng