Forum Discussion
Calulating Weekly / Yearly Rejections
Hello All, I need your help - Our team collects various weekly & yearly data and in this case the results can either be "Accepted or Rejected". Currently the raw data is retrieve from a Oracle da...
Add a year column to your first table:
Year = YEAR([Date])
Then your second table becomes:
Table4 = VAR __count = COUNTROWS(ALL('Table3')) RETURN SUMMARIZE('Table3',[Year],[Action],"Year Qty",COUNTROWS('Table3'),"%",COUNTROWS('Table3')/__count)Your third table is simply a variation of this.
Hello Greg,
Thanks you very much - I've been attempting too implemented those Power BI results you so kindly supplied for 2 weeks now :smileyvery-happy:.
Kind regards,
Thanks again,
Don
Happy to help! :)