Forum Discussion

ROG's avatar
ROG
Icon for Responsive Resident rankResponsive Resident
3 years ago

'CompletedMonth' column is required.

Hello,   Could you please help me with a dax where from my calendar table, I get only data from the completed months?   At the moment I have to keep filtering only the months that complete, which...
Need Help
Show and Tell
Tips and Tricks
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

If your calendar table is in import mode and you are refreshing it daily you can add a calculated column 

 

CurrentMonth = if(format([Date],"yyyyMM")=format(TODAY(),"yyyyMM"),1,0)

 

and then have a report wide filter setting this to 0.