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
    7 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

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 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

marcus505's avatar
marcus505
Frequent Visitor
7 years ago

Thanks a lot Frank, Greatly appreciate your help.

 

I will take it from here.

 

Thanks,