Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

MFelix's avatar
MFelix
Super User
8 years ago

Hi Anonymous,

 

Just do the sum on available day, should give you what you need.

 

Regards,

 

MFelix