![[http]](/moniwiki/imgs/http.png)
How do I group numbers in a PowerPivot PivotTable like I can in an Excel PivotTable?(http://powerpivotfaq.com/Lists/TGPPF/DispForm.aspx?ID=95)
1) If you want to start at zero i.e. 0-9, 10-19 etc, enter a formula like: =FLOOR('Number Groups'[Num],10)&" - "&CEILING('Number Groups'[Num],10)+IF(MOD('Number Groups'[Num],10)>0,-1,10-1) 2) If you want to start at one i.e. 1-10, 11-20 etc, enter a formula like: =FLOOR('Number Groups'[Num],10)+IF(MOD('Number Groups'[Num],10)>0,1,-(10-1))&" - "&CEILING('Number Groups'[Num],10) 3) 2) If you want to start at ten i.e. <10, 10-19 etc, enter a formula like: =IF('Number Groups'[Num]<10,"<"&10,FLOOR('Number Groups'[Num],10)&" - "&CEILING('Number Groups'[Num],10)+IF(MOD('Number Groups'[Num],10)>0,-1,10-1))
- Dynamic DAX Query Tables in Excel 2013(http://feedproxy.google.com/~r/wordpress/Cpjz/~3/qNayJa5iQ4E/)
- A Different Approach To Last-Ever Non-Empty in DAX(http://cwebbbi.wordpress.com/2013/01/15/a-different-approach-to-last-ever-non-empty-in-dax/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+wordpress%2FCpjz+%28Chris+Webb%27s+BI+Blog%29&utm_content=Google+Reader)
- DAX Query Basics(http://www.sqlservercentral.com/articles/DAX/92740/)
- PowerPivot Top N Reports Using Excel Cube Formulas(http://feedproxy.google.com/~r/wordpress/Cpjz/~3/GCctKKbiieA/)
- OR Selections in DAX(http://feedproxy.google.com/~r/wordpress/Cpjz/~3/Msqti02noTQ/)
- Comparing Any Two Time Periods in DAX(http://feedproxy.google.com/~r/wordpress/Cpjz/~3/wrk1chzJO6Y/)
- Solving the Events-In-Progress Problem in DAX V2.0(http://feedproxy.google.com/~r/wordpress/Cpjz/~3/mfeQGwGcJRg/)
- DAX Queries, Part 1(http://feedproxy.google.com/~r/wordpress/Cpjz/~3/gPrqQ4TjikM/)
- DAX Queries, Part 2(http://feedproxy.google.com/~r/wordpress/Cpjz/~3/OdITPznW1sk/)
- DAX Queries, Part 3(http://feedproxy.google.com/~r/wordpress/Cpjz/~3/owgpCFcHZrE/)
- DAX Queries, Part 4(http://feedproxy.google.com/~r/wordpress/Cpjz/~3/7tVWgnQtqHc/)
- DAX Queries, Part 5(http://feedproxy.google.com/~r/wordpress/Cpjz/~3/0ZDKiRg0ReY/)
- DAX Queries, Part 6(http://feedproxy.google.com/~r/wordpress/Cpjz/~3/E3JK02Ai4KY/)
- Microsoft速 SQL Server速 2012 PowerPivot速 for Microsoft速 Excel速 2010 - RTM(http://www.microsoft.com/downloads/ko-kr/details.aspx?familyid=4b5d8276-d8c8-49b3-a653-f09f744ed9c5)
- Distinct Count Measure in PowerPivot using DAX(http://sqlblog.com/blogs/marco_russo/archive/2009/12/26/distinct-count-measure-in-powerpivot-using-dax.aspx)
- Microsoft SQL Server 2008 R2 - PowerPivot for Microsoft Excel 2010 - RTM(http://www.microsoft.com/downloads/ko-kr/details.aspx?FamilyId=e081c894-e4ab-42df-8c87-4b99c1f3c49b&displaylang=ko)