Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Divide all dates values on a a specific date value from a norther column

Hi all 

I have the followeing table: 

I would like to divide all returned values  from the 4th column on only the sales from January 

How could I achieve that ? 

Thanks in advance

Regards 

 

Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Anonymous 

     

    If you try to solve it with calculated columns, it will be easy.

     

    Sales_January =
CALCULATE (
    MAX ( 'Table'[Sales] ),
    FILTER (
        'Table',
        [Date].[MonthNo] = 1
            && [Date].[Year] = EARLIER ( 'Table'[Date].[Year] )
    )
)

    %Returned/January = DIVIDE([Returned],[Sales_January])

     

     

    Best Regards,

    Community Support Team _Charlotte

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