Top 25 user document count in Numerator
Hi All, I am trying to find the top 25 users document count in Numerator. ex: 109969 count is Top 25 Users document count and 195098 is total user document count. 109969/195098= 56 % correct Now problem is when select Month then need the Top 25 users document in Numerator. Selected the Oct21 month then top 25 user count is 10039 and total count for that month 12429. 10039/12429 is required. like that for all months need. Please help on this query. Thanks in Advance.
Date Table - DAX - CALENDAR() - ADDCOLUMNS() - Quarter Issue
Hi, I create a new Date table with DAX using the CALENDAR() function. Adding new columns, no problem. When I add a new "Quarter" colum into the table my table stops starting from Jan 1st and move to start from Jul 1st. I can't understand why. Any help greatly appreciated. First Variant (correct) Date = VAR MinDate = DATE(2016,1,1) VAR MaxDate = DATE(2021,12,31) RETURN ADDCOLUMNS ( CALENDAR(MinDate, MaxDate), "Calendar Year", "CY " & YEAR ([Date]) ) Result Second Variant (wrong) Date = VAR MinDate = DATE(2016,1,1) VAR MaxDate = DATE(2021,12,31) RETURN ADDCOLUMNS ( CALENDAR(MinDate, MaxDate), "Calendar Year", "CY " & YEAR ([Date]), "Calendar Quarter", "CQ " & QUARTER([Date]) ) Result Where I am wrong? Thanks
