Forum Discussion

ajdm2007's avatar
ajdm2007
Icon for Helper III rankHelper III
2 years ago

Metrics in blank

Hi all,   I am trying to use a metric based on two tables (tickets and calendar), but for some reason, the value is returned as blank.     The total tickets metric is calculated based on t...
General Comment
Show and Tell
Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
2 years ago

Hello ajdm2007 ,

 

yes the issue is that the date column in the data table is datetime, you need to change it to date in Power query so it works.

the change should be in Power query.

  • ajdm2007's avatar
    ajdm2007
    Icon for Helper III rankHelper III
    2 years ago

    Hi Idrissshatila,

     

    I thought so, but this presents a challenge because I use the datetime field for multiple metrics, so I should not modify the column. I can think of two options:

    1. Duplicate the column and change the format to date.
    2. Adapt the relationship between the tables so that only the date is considered. I've done this in other programming languages, but I'm not sure if it's possible in this case.

     

    Thanks for your help. I’ll be attentive to your response.

     

    • ajdm2007's avatar
      ajdm2007
      Icon for Helper III rankHelper III
      2 years ago

      Hello Idrissshatila,

       

      I went through the option 1, but everything remained unchanged.

       

      Any advise?