NEED help with questions

[VishalSahoo_7]

Hello, I am new to Power BIquestionsQuestion Description, learning about it currently, Can anybody please help me with these questions I shall be grateful for it.

[Anonymous · Accepted solution]

Hi @VishalSahoo_7 ,

According to your description, you can try below five formula to create calculated table:

Blank 1: CostDifferenceMatrix = 
SUMMARIZE(
    'QuotesTable',
    'QuotesTable'[Quote ID],
    'QuotesTable'[Gold Number],
    'QuotesTable'[Pre Sales Term],
    'QuotesTable'[Pre Sales Carrier],
    'QuotesTable'[Pre Sales Cost],
    'QuotesTable'[Post Sales Carrier],
    'QuotesTable'[Post Sales Cost],
    "Cost Difference", 'QuotesTable'[Post Sales Cost] - 'QuotesTable'[Pre Sales Cost]
)

Blank 2: AvgPreSalesCostMatrix = 
SUMMARIZE(
    'QuotesTable',
    'QuotesTable'[Quote ID],
    'QuotesTable'[Gold Number],
    "Average Pre-Sales Cost", AVERAGE('QuotesTable'[Pre Sales Cost])
)

Blank 3: DateMatrix = 
ADDCOLUMNS(
    'QuotesTable',
    "Date", TODAY()
)

Blank 4: ExpectedRevenueMatrix = 
SUMMARIZE(
    'QuotesTable',
    'QuotesTable'[Quote ID],
    'QuotesTable'[Gold Number],
    "Expected Revenue", MAX(QuotesTable[Post Sales Cost])* 1.1 
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @VishalSahoo_7 ,

According to your description, you can try below five formula to create calculated table:

Blank 1: CostDifferenceMatrix = 
SUMMARIZE(
    'QuotesTable',
    'QuotesTable'[Quote ID],
    'QuotesTable'[Gold Number],
    'QuotesTable'[Pre Sales Term],
    'QuotesTable'[Pre Sales Carrier],
    'QuotesTable'[Pre Sales Cost],
    'QuotesTable'[Post Sales Carrier],
    'QuotesTable'[Post Sales Cost],
    "Cost Difference", 'QuotesTable'[Post Sales Cost] - 'QuotesTable'[Pre Sales Cost]
)

Blank 2: AvgPreSalesCostMatrix = 
SUMMARIZE(
    'QuotesTable',
    'QuotesTable'[Quote ID],
    'QuotesTable'[Gold Number],
    "Average Pre-Sales Cost", AVERAGE('QuotesTable'[Pre Sales Cost])
)

Blank 3: DateMatrix = 
ADDCOLUMNS(
    'QuotesTable',
    "Date", TODAY()
)

Blank 4: ExpectedRevenueMatrix = 
SUMMARIZE(
    'QuotesTable',
    'QuotesTable'[Quote ID],
    'QuotesTable'[Gold Number],
    "Expected Revenue", MAX(QuotesTable[Post Sales Cost])* 1.1 
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VishalSahoo_7]

Hey @Anonymous  Thank you so much really appreciate your help and efforts !! Can you please tell me the 5th blank answer?

[Anonymous · Accepted solution]

Hi @VishalSahoo_7 ,

Sorry, I missed the formula for blank5.

Blank 5: CleanGoldNumberMatrix = 
FILTER(
    'QuotesTable',
    NOT(ISBLANK('QuotesTable'[Gold Number]))
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.