Forum Discussion

comish4lif's avatar
comish4lif
Helper 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
Solution 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
    Helper 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
      Solution 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
        Helper 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?