Use columns dynamically in a calculated measure in DAX

Anonymous — Mon, 18 May 2020 08:40:31 GMT

Hi.

I have columns named "Units month 1", "Units month 2", ..., "Units month 12", which collect the sold units per month of my company.

I need to create a calculated measure based on the actual month; that is, if we're in March, I'd like the measure to use the column "Units month 3". The goal of this measure is to calculate the number of units sold during a month till a specific day, or even in the whole month.

Can I do this? Can I use the column names dynamically? What I'd like would be something like:

CALCULATE(
SUM("Units month "+MONTH(TODAY()))
)

Thanks.

Re: Use columns dynamically in a calculated measure in DAX

mahoneypat — Mon, 18 May 2020 12:28:49 GMT

It sounds like you have monthly data stored in separate columns. If so, you should unpivot those columns in the query and make your analysis much easier. Simple model, simple DAX.

If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.

Regards,

Pat

topic Re: Use columns dynamically in a calculated measure in DAX in DAX Commands and Tips

Use columns dynamically in a calculated measure in DAX

Re: Use columns dynamically in a calculated measure in DAX