Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@PBI_5 , You can not use slicer value in a calculated column, you can only use that in a measure
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |