1/17/2024 0 Comments Tabular editor 3 costMatt Allington has an article that takes you through this approach in detail. Using the custom format strings that can be defined against each calculation item, you can set a measure to display as intended. with $ and % signs where relevant).Ĭalculation groups offer a more robust alternate approach for switching between measures being displayed. Instead of dynamically updating the data type, a standard switch measure will inherit a Text type, which limits your ability to aggregate values and easily display them in the manner that you want (i.e. By default, a switch measure may refer to measures with different data types. This is typically achieved with a disconnected table and a measure that references other measures using the SWITCH function.īe aware though that a limitation of a conventional switch measure is around how the measure is formatted. SQLBI have a great article that introduces you to calculation groups for time intelligence, check it out here.Ī switch measure is a tried and true technique for changing what measure is represented in a visual using a slicer. You can also slice between them, or show them all together at once (see below). Each of the time intelligence calculations can then be accomplished by filtering your visuals to use only one calculation item. The alternative is to create a calculation group and define these calculations once. Defining each of these calculations for Sales is fine, but if you want to also perform these calculations against your Margins or your Cost of Goods Sold, you’ll end up with way more measures that become harder and harder to maintain. If you have a Sales measure, you may want to implement time intelligence to see how your Sales stack up as far as week to date, year to date, month on month change, same period last year, etc. This is the standard application of calculation groups. Alright, now after those disclaimers, let’s dig into our list of 10 awesome applications of calculation groups, starting with the most obvious… 1.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |