topic NEED help with questions in DAX Commands and Tips

NEED help with questions

VishalSahoo_7 — Wed, 03 Jul 2024 14:45:04 GMT

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

Re: NEED help with questions

Anonymous — Thu, 04 Jul 2024 07:06:15 GMT

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.

Re: NEED help with questions

VishalSahoo_7 — Thu, 04 Jul 2024 08:03:15 GMT

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

Re: NEED help with questions

Anonymous — Thu, 04 Jul 2024 08:17:10 GMT

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.