Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need help with DAX Formulation for sum using equality operator Date columns

Hi, I have an input method format as shown below in the image(which is obtained through powerapps)   Where the input date has a 'one to one' relationship with the dim date table Illustratio...
firstnonblank
sum
values
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

    this code might work

    Output=VAR vCurrentDate=max(dimDateTable[Date]) RETURN CALCULATE(SUM(Input[Value]),Input[Date]<=VCurrentDate)

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

this code might work

Output=VAR vCurrentDate=max(dimDateTable[Date]) RETURN CALCULATE(SUM(Input[Value]),Input[Date]<=VCurrentDate)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks mate!

Worked like a charm