QTD and cumulative QTD

[prashantnegi]

Hello All,

I am a beginner of PowerBI. I have some data like:

Emp Name     Skill Name      Updated Date
Raj                  Skill 1             06-Aug-2017
Rahul              Skill 2            12-May-2018
Manoj             Skill 1           06-Apr-2019
Roy                 Skill 2           09-June-2019

From above data I want to display QTD of skills count and cumulative QTD skill count (current QTD count + all previous QTD count(without date consideration)).

Also can I see the top 5 skills(count) in graph or pie chart by clicking on QTD?

Total QTD = TOTALQTD(count(table1[Skill Name]),table1[Updated Date])

Above measure gives QTD skill count for quarter but dont know how to add cumulative skills count to that QTD? Please help.

[v-lili6-msft · Accepted solution]

hi, @prashantnegi 

You could get it just by this formula:

cumulative skills count = CALCULATE(count(table1[Skill Name]),FILTER(ALL(Table1),table1[Updated Date]<=MAX(Table1[Updated Date])))

Best Regards,

Lin