Forum Discussion
JustinDoh1
Post Prodigy
Post ProdigyCalculate function - filter
I am trying to understand this DAX code here.
DAYSINMONTH =
day(calculate(
ENDOFMONTH('Calendar'[Date]),
...
I don't think the post initiator, so far, wraps his/her head around my solution in another post of his/hers.
Solved: How to reference a value on related table - Microsoft Power BI Community
CALCULATE filters are actually tables.Indeed, this is how filters works in DAX. It's an explicit leveraging of Expanded Table in such statements, CALCULATE( XXX, Table ).
JustinDoh1Post Prodigy
Post ProdigyTable1 is a name of a table.
I am getting error mesage.
Update:
I have updated the Pbix file, and bottom are illustrations of two cases:
littlemojopuppy
Community Champion
Community ChampionJustinDoh1 I assumed it was a table. Whole thing seems unnecessary.
I didn't use ENDOFMONTH. I used EOMONTH (returns the last day of a month with offset by number of months).