Create a Custom Calculated Table

[RenanPNog]

Hello guys!

I need help on how to create a specific calculated table.

I have my Fact table, where there is all sales records. 
I'll link in this post a dummy file that represents my fact table.

Here's the sample:

For example:

group_name "Cars", product "Volvo", status "Old", starts on 07/12/2022 and ends on 15/08/2023.

group_name "Cars", product "Ferrari", status "Old", starts on 23/11/2022 and ends on 06/05/2023.

To make this example easy, let's assume that min date of group_name "cars", status"old" is 23/11/2022, and max date is 15/08/2023.

Result i need: a calculated table that shows for every product with status context a column that contains values from the min date to max date.... So in the new table, row 1 would be "volvo" - "old" - 23/11/2022 and row X (last row of specific product) would be 15/08/2023.

Basically, ignoring the product date context and bringing only group_name and Status filter. 
I've tried to do some Summarize Functions but didn't work.

https://docs.google.com/spreadsheets/d/1g1ywBueUUNO-cRjJl5gu4huIRD0tNip3KJzVjewBgWE/edit?usp=sharing

[FreemanZ]

hi @RenanPNog 

are you expecting:

Table =

SUMMARIZE(

    TableName,

    TableName[products],

    TableName[status],

    TableName[day]

)

[RenanPNog]

Hey there, FreemanZ. 

Not really. Because if I do SUMMARIZE function, it will returns me the respectives days of each product, and I want for each product to shows me the minimum and maximum date of group_name

[FreemanZ · Accepted solution]

hi @RenanPNog 

something like:

Table =

VAR _table =

SUMMARIZE(

    TableName,

    TableName[products],

    TableName[status]

)

RETURN

ADDCOLUMNS(

    _table

    "MinDate",

  CALCULATE(MIN(TableName[day])),

    "MaxDate",

  CALCULATE(MAX(TableName[day]))

)

[RenanPNog]

Hello, mate!

Not 100% what i needed, but i think summarize will do it anyways. Thanks in advance!