Forum Discussion
Filters affecting Dynamic Text
Hello, I have a text box that populates key dates for a given report. These dynamic values sometimes will not populate when the user filters the report, and I can't understand why. Has anyone com...
hnguy71 yes sorry if that was confusing at all.
For the screenshot where it shows "11/1/2024", that is coming from this calculated column:
STARTDATE_BOM = DATE(YEAR(DEMAND[STARTDATE]),MONTH(DEMAND[STARTDATE]),1)
In this DAX calculation, STARTDATE is just the current date, and it is populated for every row in the dataset. I am effectively truncating it to the beginning of the month.
hi Anonymous ,
try like:
STARTDATE_BOM =
EOMONTH(MAX(DEMAND[STARTDATE]), -1)+1
Unfortunately this results in the same outcome with the value not populating