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

[Anonymous]

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

Illustration Purpose: This is how values are stored in the dashboard

     Dim input table     

DAX Formula

By using the above formulation I want to achieve the following output:

But I get this as my output

Am I missing out something in the formulation?

[Anonymous]

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 2020	0
dec 2020	0
jun 2021	300
dec 2021	300
jun 2022	300
dec 2022	300

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

jun 2020	0
dec 2020	0
jun 2021	0
dec 2021	0
jun 2022	100
dec 2022	100

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

[wdx223_Daniel · Accepted solution]

this code might work

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

[Anonymous]

Thanks mate!

Worked like a charm

[AntrikshSharma]

@Anonymous  Try something like this:

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