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)

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

Anonymous  Try something like this:

=
SUMX (
    DimInputTable,
    DimInputTable[Column 1] + DimInputTable[Column 2] + DimInputTable[Column 3]
)