Forum Discussion

marcus505's avatar
marcus505
Frequent Visitor
8 years ago
Solved

Fiscal Year Calculated Columns

Hi,   I am trying to create calculated columns that bring out results per Quarter / month per month based on type of caller.     For example   If Month = April and Year = 2018 and Type ...
  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    Hi marcus505,

     

    Yes, here you should update your formula like this.

     

    Measure = CALCULATE(SUM(fabric_swishs[fabric_typeofcaller]),FILTER(fabric_swishs,fabric_swishs[fabric_dateofcall].[Month]="August" && fabric_swishs[fabric_dateofcall].[Year]=2018 && fabric_swishs[fabric_typeofcaller]=

555510002))

    Regards,

    Frank

GilbertQ's avatar
GilbertQ
Super User
8 years ago
Hi there

You could try this:

My Measure = CALCULATE(SUM(fabric_swishs[Fabric]), TableName[Month] = "April" && TableName[Year] = "2018" && TableName[Type of Caller] = "email")