Forum Discussion

shabirAhmad's avatar
shabirAhmad
Icon for Helper II rankHelper II
3 years ago
Solved

Integer number divide by Measure in DAX

Hi Experts,

 

I want to divide simple Number 365 by Measure how can i do this.

Inventory Days   =  365 Days(Number which is not exist in table only a number)/ Inventory Turns (Measure)

 

Please need your support on aboce DAX formula.

 

Best Regards,

Shabir Ahmad

Need Help

3 Replies

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago

    Inventory Days = DIVIDE(365, [Inventory Turns],0)

    • shabirAhmad's avatar
      shabirAhmad
      Icon for Helper II rankHelper II
      3 years ago

      Hi Ahmedx,

       

      Thanks for your prompt response, if this invntory Turns is a table field then what we will do thanks for your support.

       

      Best Regards,

      Shabir Ahmad

    • shabirAhmad's avatar
      shabirAhmad
      Icon for Helper II rankHelper II
      3 years ago

      Hi Ahmed 

      Thanks i did it as below in case of table field

       

      Inventory Days = DIVIDE(365, SUM(UETURNSANDDAYSVIEWPOWERBI[InventoryTurns]))
       
      Best Regards,
      Shabir Ahmad