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)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi AntrikshSharma ,

Thanks for the reply 

But my values dont get stored as different columns but as a single view for each input case

For example: For input- Input value- 300 @ input date: jun 2021

jun 20200
dec 20200
jun 2021300
dec 2021300
jun 2022300
dec 2022300
 

For input- Input value- 100 @ input date: dec 2021

jun 20200
dec 20200
jun 20210
dec 20210
jun 2022100
dec 2022100

So each of it is a single view and then finally i want to add them similar to final input above

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