How to create a Parameter to display data dynamically

[Kumar_0606]

Hello Experts,

I have a date field. I want to display data dynamically so that whenever User selects particular date, data should be filtered accordingly.

I created a Date parameter (transform data-> New Parameter) with some Values and joined (Many to One) with the actual table.

Now I am trying to create a calculation 

Flag Current Month=YEAR(Table[Date]) = YEAR(Paramter table[Date])

 Here I'm unable to select the Parmater Date as they are not populating.

Am i missing something or is there any other way to create the flags CM, PM, CY, PY etc.

Thanks in advance

[bhanu_gautam]

@Kumar_0606 You need to create calculated fields to flag the current month, previous month, current year, and previous year based on the selected date parameter.

FlagCurrentMonth =
IF(
YEAR(Table[Date]) = YEAR(SELECTEDVALUE(ParameterTable[Date])) &&
MONTH(Table[Date]) = MONTH(SELECTEDVALUE(ParameterTable[Date])),
1,
0
)

FlagPreviousMonth =
IF(
YEAR(Table[Date]) = YEAR(SELECTEDVALUE(ParameterTable[Date])) &&
MONTH(Table[Date]) = MONTH(SELECTEDVALUE(ParameterTable[Date])) - 1,
1,
0
)

FlagCurrentYear =
IF(
YEAR(Table[Date]) = YEAR(SELECTEDVALUE(ParameterTable[Date])),
1,
0
)

FlagPreviousYear =
IF(
YEAR(Table[Date]) = YEAR(SELECTEDVALUE(ParameterTable[Date])) - 1,
1,
0
)

Make sure that your parameter table is properly linked to your main table. The SELECTEDVALUE function is used to get the value of the parameter selected by the user.

[Kumar_0606]

Hello Gautam,

Thanks for the reply.

I created Current Month flag as you suggested and created a column like

Amount CM= IF ([Flag Current Month]=1 && Table[Version]="New", [Amount]))

When i pulled this to the table, getting Blank value.