How to create a calculated column with same value in every row with a calculated value

Anonymous — Wed, 21 Feb 2024 23:22:21 GMT

Hi,

I am trying to create a calculated column using DAX Calculate function.

I want all my rows to have the same value that was calculated using CALCULATE function.

I want all rows of thisFiscalWeek column to be populated with the outcome of CALCULATE function.

When I use this code it is only populating one row. I want that value to be in every row.

thisFiscalWeek = CALCULATE(MAX('Date Hierarchy'[fiscalWeek]), 'Date Hierarchy'[rDate] = 0)

Thank you for you help in advance

Re: How to create a calculated column with same value in every row with a calculated value

some_bih — Thu, 22 Feb 2024 07:05:51 GMT

Hi Anonymous

picture is not visible- too small. Still, try v2 below

thisFiscalWeek v2 =

CALCULATE(MAX('Date Hierarchy'[fiscalWeek]), 'Date Hierarchy'[rDate] = 0, ALL())

topic How to create a calculated column with same value in every row with a calculated value in DAX Commands and Tips

How to create a calculated column with same value in every row with a calculated value

Re: How to create a calculated column with same value in every row with a calculated value