topic Multiple Calculated column depending upon one parameter in Developer

Multiple Calculated column depending upon one parameter

Anonymous — Mon, 14 Aug 2023 10:21:12 GMT

I am trying to make two different columns whoes values should be depended on the parameter value selected in slicer,
like when i select option 1 the values of those two columns should change, and if i choose option 2 then both column values should change accordingly.
So let me give a example, there is a parameter called period which contain four values monthly, quarterly, half yearly, and yearly, i want to make one column which will show the date monthly if monthly is selected, quarter wise if quarterly is selected and so on, similarly there i want one more column to change its value according to the value selected by period paramter, how can i do that. I can do it if there was only one column using field parameter but how can i do with multiple column, please help.

Re: Multiple Calculated column depending upon one parameter

Anonymous — Wed, 16 Aug 2023 09:04:42 GMT

Hi @Anonymous,

I suggest you to create a Calendar table and then use Fields Parameters.

Calendar = ADDCOLUMNS ( CALENDAR ( DATE ( 2023, 01, 01 ), DATE ( 2023, 12, 31 ) ), "Year", YEAR ( [Date] ), "Quarter", "Q" & "" & QUARTER ( [Date] ), "Month", FORMAT ( [Date], "MMMM" ), "MonthSort", MONTH ( [Date] ) )

Field Parameter:

Add Period in Axis field in your visual.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Multiple Calculated column depending upon one parameter

Anonymous — Thu, 17 Aug 2023 05:27:32 GMT

Hi @Anonymous,
I have not the problem in changing the date format using slicer, that I can do it was just an example but i want one more column to change with the change in selection of slicer, that i cannot do it with the field parameter, so can to tell me how to do it