Below Cognos Expressions need to convert this to Power Bi Dax.

[anjanikumar]

Below Cognos Expressions need to convert this to Power Bi Dax.

1 [Fiscal Year and Period] Between #sq($Jarvis_Parameter_Map_Non_Dates{'PRIOR_PREV_FISCAL_PERIOD'})# and       #sq($Jarvis_Parameter_Map_Non_Dates{'CURR_PREV_FISCAL_PERIOD'})#

2     percentage ([Invoice Sales] for [Fiscal Year and Period])

Jarvis_Parameter_Map_Non_Dates is table.

[v-binbinyu-msft · Accepted solution]

Hi @anjanikumar ,

Please try below dax formula, but  you need adjust it  according to your environment

1. 

a =
FILTER (
    ALL ( 'Jarvis_Parameter_Map_Non_Dates' ),
    [Fiscal Year and Period] >= 'Jarvis_Parameter_Map_Non_Dates'[PRIOR_PREV_FISCAL_PERIOD]
        && [Fiscal Year and Period] <= 'Jarvis_Parameter_Map_Non_Dates'[CURR_PREV_FISCAL_PERIOD]
)

2.

b =
DIVIDE ( [Invoice Sales], [Fiscal Year and Period] )

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.