![]() With this measure, I will be able to analyze Total Cost, Total Margin, and Total Sales.įor the previous month’s sales, we have to use both the CALCULATE and SELECTEDMEASURE functions. So instead of having to write previous month sales over here, I’m just using one measure. The first calculation item we are going to create is the previous month calculation. To create measures or calculation items, right click and choose Calculation Item. We can name this group as Time Intelligence. Let’s create calculation groups by right-clicking on the Tables calculation group, clicking on Create New, and choosing Calculation Group. You can see that the Total Cost depends on this table and this column. I can right-click on Total Costs and click on Show Dependencies.Īs you can see, the Total Margin is dependent on Total Costs.īut if you want to check which measure, table, or columns our Total Cost measure is dependent on, you can click here. For example, I want to check which measures depend on the Total Costs measure. ![]() You can also check your dependent measures from the Tabular Editor. For example, Channel, Sales, and Stores are here. The cool thing about Tabular Editor is that you can access all your tables from this tool. ![]() How To Make Calculation Groups Using Tabular Editorįirst, you will have to go to External Tools then click on Tabular Editor. We can avoid all of this with Tabular Editor. To do this, you will have to calculate three more measures for every time intelligence calculation. Let’s imagine that you want to create more time intelligence calculations, such as previous year, quarter on quarter, or month over month percentage change. So that’s a total of six more measures that I need to create. For Total Margin, I also have to create three measures. But what if I wanted to see the same result for Total Cost? I have to create three additional measures. To be able to analyze sales in different time periods, I had to calculate three measures. I’ll also add our current total sales, our previous month sales, our previous quarter sales, and month-over-month change. We can populate this in a matrix visual and analyze it by month name. The month-over-month change measure is basically the difference between Total Sales and Previous Month Sales. The only difference is that month was replaced by quarter. This same measure was used in the previous quarter sales measure. I used the time intelligence function to get the previous month. I want to check our previous month’s sales, previous quarter’s sales and month over month change. Why should we create calculation groups when we can get the same results with our measures? Well, we have created three measures in our report for demonstration purposes: Total Sales, Total Cost, and Total Margin. How To Make Calculation Groups Using Tabular Editor.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |