Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
i would like to reference the two date values form a Slicer i have on a Canvas into a DAX formula (new column)...?
thank you.
PowerBI does not support dynamic Calculated Columns (meaning, the values of CalculatedColumns cannot change once set, based on slicer values, etc.). You would need to create a Calculated Measure instead, to capture the selected value. And use that calculated measure in your DAX.
More details here:
thank you.
i'm OK using the SelectValue function, but i don't know how to reference the Slicer and each of the two dates listed in the object's text boxes...?
???
thank you.
Each slicer uses one field from the data model. In case your case, you have two slicers for two date fields. And you can use SELECTEDVALUE(YourTableName[YourDatefield]) to get the selected value of the slicer.
thank you.
in my Slicer object, there are two text fields from one field.
i would like to use these Slicer text boxes as Start and End dates (this works fine for filtering).
but i'm not referencing these dates in my DAX formula?
thank you!
working on it and more to follow ASAP.
thank you.
good news, i can reference the two dates in the Slicer (thank you!).
now, i'm trying to get the date range between these two (to use in an If statement) and i get following error:
Error Message:
MdxScript(Model) (6, 44) Calculation error in measure 'cpq quotesMikeII'[SelectedBetween]: A date column containing duplicate dates was specified in the call to function 'DATESBETWEEN'. This is not supported.
using:
some success...!
thank you.
the good news is the function doesn't error out.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
18 | |
16 | |
16 | |
16 |
User | Count |
---|---|
26 | |
26 | |
19 | |
15 | |
14 |