Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Visuals input

Hello   How can I feed variables from the dashboard (e.g. filters, drop down selections, slicers) to DAX or Power Query? E.g. select a value from a drop down in the dashboard and use it in DAX or ...
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    Calculated column is a static column of an entity, it cannot be changed according to the slicer in Table 1, so measure must be used, no relation is needed here.
    You can try to create measure as follows:

    measure = IF(MAX(Table2[Date])>min(Table1[Date]),"something","something else")

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Anonymous ;

Calculated column is a static column of an entity, it cannot be changed according to the slicer in Table 1, so measure must be used, no relation is needed here.
You can try to create measure as follows:

measure = IF(MAX(Table2[Date])>min(Table1[Date]),"something","something else")

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.