Forum Discussion
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...
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
Super User
Super UserYou 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.