Forum Discussion

vvv's avatar
vvv
New Member
3 years ago

PowerBI Table and Chart

Hi, Below is my sample data and result needed, i am trying in calculated column but its giving count for each month , but not like i am expecting the result set.   Please help me with the DAX or Ca...
JW_van_Holst's avatar
JW_van_Holst
Resolver IV
3 years ago

This are the two tables I use:

and this is the DAX code

_result = 
VAR EOM = MAX(MonthYear[End of Month])
VAR _filter = FILTER(Transactions, Transactions[EndDate] <= EOM)
RETURN
COUNTROWS(_filter)

and this is the result: