Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Store parameters values in a variable

Hey folks, I am working on a code where I am making summarize table in which I am comparing the performance 'X' days before and 'X' days after the date of installation. It is working fine. Now I wan...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 

The calculated table is the static table, it will not change by the paramater, so when you select one paramater, it will give the blank value, because the paramater is not existd in the table, you can consider to create a virtual table by using measure, then filter the related value from the virtual table,

e.g 

dateinrange =
VAR daysbefore =
    SELECTEDVALUE ( VarDays[VarDays] )
VAR _virtualtable =
    the function you create the table
RETURN
    MINX (
        FILTER (
            _virtualtable,
            [Meterkey] IN VALUES ( Flow_Value_Daily_Consumption[Meterkey] )
        ),
        [Sum of Test]
    )

Best Regards!

Yolo Zhu

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hey 
Thanks its really great
But [Sum of test] is just for testing, I am filtering the table by passing parameter value in the variable if you can see the DAX above where VAR daysbeforafter=SELECTEDVALUE(VarDays[VarDays]),

Any number in that variable will go through dax and change the function accordingly, is that make sense?

I really appreciate your support
Thanks you