Forum Discussion

dexter00000's avatar
dexter00000
Icon for Helper I rankHelper I
2 years ago
Solved

Slicing a table by Month and Year From Same Date Table

Hi,   I have a date table and another table. Both have YEAR,MONTH columns. But because there is only 1 active connection i can only slice YEAR or MONTH.I don't want to multiply the date table to us...
Need Help
dexter00000's avatar
dexter00000
Icon for Helper I rankHelper I
2 years ago

so this is how it looks with additional columns. 

I only have 1 dates table and no other dimension tables year will slice the fact table and month will too they can be used together. But also separately too. Is this achievable?

 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    You don't have a Dates table yet. The Date column is missing. For Time Intelligence functions to work that date column must be contiguous (no gaps) and covering (including the result of the time intelligence).

     

    Please show a sanitized version of your data model.

    • dexter00000's avatar
      dexter00000
      Icon for Helper I rankHelper I
      2 years ago

      I didn't include them in the picture but it's like this.

       

      • dexter00000's avatar
        dexter00000
        Icon for Helper I rankHelper I
        2 years ago

        AY,DÖNEM are the same thing. Messing around got those a bit confusing. Basically AY,DÖNEM(MONTH) and YIL(YEAR) will be sliced by the date table. But i don't know how will i achieve it with only 1 connection.