Forum Discussion

Raul's avatar
Raul
Post Patron
5 years ago
Solved

DAX Formula for a date field

Hello Community!   I have the Calendar table related to the Table1 table by the field Calendar[Date] - Table1[Date] and related to the Table2 table by the field Calendar[Date] - Table2[Date]. I ne...
Need Help
  • Raul's avatar
    Raul
    4 years ago

    Of course:

    Measure = 

       VAR varYear = SELECTEDVALUE(Calendar[Year])
       VAR varPVY = CALCULATE(SUM(Table2[Amount]), ALL(Calendar), DATESBETWEEN(Table2[Date], DATE(varYear+1,09,01), DATE(varYear+1,12,31)))
       VAR varACY = CALCULATE(SUM(Table1[Amount]), ALL(Calendar), DATESBETWEEN(Table1[Date], DATE(varYear,01,01), DATE(varYear,03,31)))
    RETURN
       varPVY + varACY
     
     
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Raul,

I'm glad to hear you find the solution.😊

BTW, did you mind sharing a sample formula for this? I think it will help other users who were looking for a similar formula.

Regards,
Xiaoxin Sheng

Raul's avatar
Raul
Post Patron
4 years ago

Of course:

Measure = 

   VAR varYear = SELECTEDVALUE(Calendar[Year])
   VAR varPVY = CALCULATE(SUM(Table2[Amount]), ALL(Calendar), DATESBETWEEN(Table2[Date], DATE(varYear+1,09,01), DATE(varYear+1,12,31)))
   VAR varACY = CALCULATE(SUM(Table1[Amount]), ALL(Calendar), DATESBETWEEN(Table1[Date], DATE(varYear,01,01), DATE(varYear,03,31)))
RETURN
   varPVY + varACY