Forum Discussion
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
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?
this code might work
Output=VAR vCurrentDate=max(dimDateTable[Date]) RETURN CALCULATE(SUM(Input[Value]),Input[Date]<=VCurrentDate)
4 Replies
Anonymous Try something like this:
= SUMX ( DimInputTable, DimInputTable[Column 1] + DimInputTable[Column 2] + DimInputTable[Column 3] )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
this code might work
Output=VAR vCurrentDate=max(dimDateTable[Date]) RETURN CALCULATE(SUM(Input[Value]),Input[Date]<=VCurrentDate)
