Forum Discussion

Arnault_'s avatar
Arnault_
Icon for Resolver III rankResolver III
7 years ago
Solved

Inventory position

Hi All,   I am stuck with something that is probably very simple. I am trying to calculate an inventory position.  Here is a simplified dataset with 2 tables : a fact table corresponding to stock ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Arnault_ 

     

    Make sure you've changed the data type to Date in Query Editor.

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

Arnault_ 

 

Make sure you've changed the data type to Date in Query Editor.

  • Arnault_'s avatar
    Arnault_
    Icon for Resolver III rankResolver III
    7 years ago

    Hi v-chuncz-msft ,

    Thanks for your help. Following your recommendation I changed date/time type to time type and it works now. If I understand well the problem, DAX considers these are two different types and that's why the relation between my calendar table and my fact table was not working. I wasn't expected that.

    Many thanks for your help.