Find origin and behaviour of legacy dataset calculated table in PBI Desktop

[Agucho76]

Hi,

I am working with a legacy dataset created by others. It has a calculated table (Vencimientos facturas) that generates me several doubts. As said, this is the dataset pbix, so no access permissions limitations.

1. It seems to be a calculated table, but it does not show any Dax formulas when I click on it.
2. It has two columns, but I only see one in the right pane (Unhide All already selected)
3. It has no relationships with other tables

    

   1. 
4. Nevertheless, when used as column in a matrix visual, it works like a charm
5. It even assigns a special currency format to values, adding the currency of values displayed that can be different in each row. 

Of course it is not in Power Query.

How can I find and edit the origin and behaviour of this table? I want to learn what it is and how it has been set to recognize groups of invoices whether they are overdue or not, and add currency name to values.

Thanks!!

[amitchandak · Accepted solution]

@Agucho76 , This is a calculation group table

https://www.sqlbi.com/calculation-groups/

https://powerbi.microsoft.com/en-nz/blog/deep-dive-into-the-model-explorer-with-calculation-group-au...

[Agucho76]

Thanks Man!! You rock!!

Now I need to study 😉 

Have a great one,
Agus.