Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Need help in DAX

Hi,   I have below table. I don't have Previous Day column and wanted create Total Value column as per the below table. Is it possible to get that. The first date in a month I wanted to pass as zer...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

My proposal produces the same result, but in a simplified manner, without the need for intermediate columns.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

What will happen if 4th day get Totalvalue as zero, then I should be doing Targetvalue-Previous day value (then my previous day value shouldn't be running sum, I should pass as zero. that scenario will get failed above solution.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    You cannot do conditional aggregations in DAX. They are only possible in Power Query.

     

    Please provide sample data that fully covers your issue.
    Please show the expected outcome based on the sample data you provided.