Forum Discussion

macemit's avatar
macemit
Frequent Visitor
7 years ago

Calculation Help with growing column

Hi,   Another calculation quandry.  It'll help if you see a sample first: Release Date:       May-18         Months Since Release (M) Fails (F) M x F (May) 5 12 60 (June...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi macemit,

 

I made one sample for your reference. If it doesn't meet your requirement, kindly share your sample data or pbix to me.

 

1. Enter the sample data and create a calculated column in the table.

 

Month = FORMAT(RELAEASE[date],"mmmm")

2. Create the measures as below.

 

Months Since Release = DATEDIFF(MAX(RELAEASE[date]),TODAY(),MONTH)+1
M = [Months Since Release]*SUM(RELAEASE[Fail])
M x F = SUMX(RELAEASE,[M])

 

For more details, please check the pbix as attached.

 

Regards,

Frank

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi macemit,

     

    Does that make sense? If so, kindly mark my answer as a solution to close the case.

     

    Regards,
    Frank