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

What is your definition of "completed" ?  Is your data source in import mode? how often is it refreshed?

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

    Hi lbendlin  thanks for your reply.
    My calendar table is in import mode, but the fact table is direct query.

    At the moment I can the metrics by month, but for the current month, I'm getting MTD, but it gives the impression we are not doing well compared to previous months. So, I had another column, which could be just true/false to flag, when the month is complete it would be really helpful. Thanks!