Use columns dynamically in a calculated measure in DAX

[Anonymous]

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.

[mahoneypat · Accepted solution]

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