How to write the expression ?

[suvechha_b]

I have declare the following :

MonthPeriod:

Load * inline [

     Fiscal Month,Period   

     Jul,1

     Aug,2

     Sep,3

     Oct,4

     Nov,5

     Dec,6

     Jan,7

     Feb,8

     Mar,9

     Apr,10

     May,11

     Jun,12   

     ];

one variable : vPrevious :Month(AddMonths(Date(Today()),-1)) which gets the value " feb "

I want to use the value 8 from the inline function MonthPeriod for the below expression :

sum({<[fis_period] = {8} >}[Stag Forecast Units])

as fis_period use 8 instead of feb .

But the above query is incorrect . Please help me to write the expression.

[MK_QSL]

Can you load your sample file or sample data along with your requirements?

[#3]

Hi,

Try this

Create a variable

vPrevMonth= NUM(Month(AddMonths(Today(),6-1)))

SUM({<[fis_period] = {$(vPrevMonth)}>}[Stag Forecast Units])

or

=SUM({<[fis_period] = {'$(=NUM(Month(AddMonths(Today(),6-1))))'}>}[Stag Forecast Units])

Note: Differance in your calender and our calender

your calender starts from Jul

[suvechha_b]

See the field sample .

SUM({<[fis_period] = {'$(=NUM(Month(AddMonths(Today(),-1))))'}>}[Stag Forecast Units])

the above expression is giving value of fis_period = 2

but I want fis_period as 8 thus I have declare in Inline Tab :

MonthPeriod:

Load * inline [

     Fiscal Month,Period   

     Jul,1

     Aug,2

     Sep,3

     Oct,4

     Nov,5

     Dec,6

     Jan,7

     Feb,8

     Mar,9

     Apr,10

     May,11

     Jun,12   

     ];

feb, 8

PFA.

[PrashantSangle · Accepted solution]

Hi,

Go to vw_fact_dop_forecast_stagger table

rename fis_period field as Period

OR

fis_period field as [Fiscal Period]

So that You can create Link between vw_fact_dop_forecast_stagger and Your Inline Table

Then Use Your Expression,

It will work correctly,

Regards,