Forum Discussion
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 ...
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.
This is done automatically via the filter context.