Forum Discussion

comish4lif's avatar
comish4lif
Icon for Helper II rankHelper II
8 years ago

Column reference... cannot be used with a variation 'MonthNo' because it does not have any

I have a measure that was working previously, but is no longer working after a data refresh. The following function:   Requests Completed by Month = COUNTX(FILTER('Production Approval Workflow', 'P...
Need Help
v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

Hi comish4lif,

 

First the error has nothing to do with Null dates.

 

 

And I can repro your issue. If I disable the Time intelligence (Auto Date/Time) option in File/Options and Settings/Options/Data Load. The error shows up.

 

 

Thereby, please verify your Time intelligence setting.

 

Thanks,
Xi Jin.

comish4lif's avatar
comish4lif
Icon for Helper II rankHelper II
8 years ago

Xi Jin, 

 

Thanks for the response - but the Time Intelligence was selected (it had the checkmark).

 

I unchecked Time Intelligance and a bunch of visualizations and measures that were working then became broken.

 

Any other suggestions?

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Hi comish4lif,

     

    One possibility. Have you created any relationships on this table 'Production Approval Workflow'? Relationship can affect date hierarchy. Please verify this.

     

    Thanks,
    Xi Jin.

    • comish4lif's avatar
      comish4lif
      Icon for Helper II rankHelper II
      8 years ago

      Do I have relationships on that table? Only about 9.

       

      What type of relationship should I be looking at as the source of my problem?

       

      • v-xjiin-msft's avatar
        v-xjiin-msft
        Icon for Solution Sage rankSolution Sage
        8 years ago

        Hi comish4lif,

         

        Ok. It's hard to say. Could you please share us your pbix file with OneDrive if possible? So that I can know your actual situation and make some proper tests.

         

        If you can't share us the file. I would suggest you check all the relationships one by one. Start from date columns.

         

        Thanks.
        Xi Jin.