Indexing a temporary table

[Ste_For94]

Hi Everyone

I'm having trouble indexing a temporary table generated through summarize.

Basically I have two variables: one stores the current cluster, the other one is a table with two columns, the first stores the cluster and the second the number of components for that cluster.

Now what I need to do is to extract the number of components for the current cluster, I wanted to filter the temporary table and use max to get the single value, but i can't index the table as it is stored in a variable.

[AntrikshSharma]

not enough information to provide a solution, I can't visualize what you want to do, can you share some sample data, with what you have tried so far?

[Ste_For94]

Ok I used another solution for the previous problem, but I got stuck in the same issue again in another simpler DAX generated table: I created a parameter that represents the month number. I use it in a report so that if I select the month number I get the report for that specific month. Now what I want to do is to upgrade that parameter so that it shows the name of the month instead of the number.

the original parameter is Parametro_Mese = GENERATESERIES(1, 12, 1)
to upgrade it i wanted to do something like

Parametro_Mese =
VAR MONTH_NUMBER = GENERATESERIES(1, 12, 1)
VAR Tabella = ADDCOLUMNS(MONTH_NUMBER,"MONTH_NAME",...
and to use as an expression for the added month_name column a condition such as
IF( n > 0 && n < 13 , -- THEN -- FORMAT(DATEVALUE("2018-" & n & "-1") , "MMM") , -- ELSE -- "Other" )

now my problem is: how do I index the column generated in the var Month_Number to get the n value?

hope this time I made myself clear 🙂