Let's first take a look at how calculation groups appear to users in a reporting tool like Power BI. For the user, this can mean having to sort through just as many measures, and apply them individually to their report. The data modeler has to create separate measures for each calculation, which can lead to dozens of measures. For example, a sales analyst wants to view sales totals and orders by month-to-date (MTD), quarter-to-date (QTD), year-to-date (YTD), orders year-to-date for the previous year (PY), and so on. Calculation groups address an issue in complex models where there can be a proliferation of redundant measures using the same calculations - most common with time intelligence calculations.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |