Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi everyone,
Im having trouble trying to get the max date from my slicer as a variable for the column that i want. currently i have measure to get the selected date. But while using this measure in another table, no value is copied.
this is the measure maxdate6 i created
as you can the measure has gotten the value but when i try to copy into a column in a table, nothing comes up
Can anyone help with this, any other way is also appriciated.
Hi @PBI_5,
Power bi does not support create dynamic calculated column/table based on filter. They do not work on the same level, and you can't use their child to affect its parent level.
Notice: the data level of power bi(from parent to child level)
Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)
Regards,
Xiaoxin Sheng
User | Count |
---|---|
84 | |
75 | |
63 | |
51 | |
45 |
User | Count |
---|---|
101 | |
43 | |
39 | |
39 | |
36 |