Forum Discussion

Talvien's avatar
Talvien
Icon for Helper I rankHelper I
10 years ago

Push

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Talvien

     

    You could try the following.

     

    1. In the Budget Table create a column called BudgetDateKey and this should be a nwhole number  like YYYYMMDD.

    2. Similarly create a column AcutalsDateKey in the Actuals table and this should be a whole number like YYYYMMDD.

    3. I am assuming the DateInt in the calendar table is also of the same YYYYMMDD  format.

    4. Join the tables using the BudgetDateKey with Dateint and ActualsDateKey with Dateint.

    5. You can now use a measure called BudgetTillNow defined

         as CALCULATE( [Budget], DATESYTD( 'Calendar'[Date] ) )

    6. Similarly you can define for AcutalsTillNow.

     

    Checkit out and if it works please mark this as a solution and also give kudos.

     

    Cheers

     

    CheenuSing

    • Talvien's avatar
      Talvien
      Icon for Helper I rankHelper I
      10 years ago

      Hi Anonymous,

       

      thanks for your answer, I have some questions on your solution.

       

      1. In the Tables Actuals, Budget and Calendar I have a column with Date (Datetyp: Date). Why isn't this enough relation between them?

      2. What do you mean by "Join"? Join them in an additional table? Or join them in DAX?

      3. Doesn't the CALCULATE need an additional operator? Something like CALCULATE( SUM( 'Budget'[Budget] ), DATESYTD( 'Calendar'[Date] ) )

       

      I really appreciate your help!