Forum Discussion

Vishalsurve7's avatar
Vishalsurve7
New Member
2 years ago

Dax

Create measure to sum of all previous april month value from value column  before any selected date(reportdate) in slicer.. Note- report date column is like only last two date for each month per y...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Vishalsurve7 ,

Whether your problem has been resolved? If no, could you please provide your expected result base on your provided sample data?

For example -   report date         value   currency

                           30-jan-2020       100       EUR

                           31-jan-2020       200       GBP

                           28-feb-2020       400       EUR

                           29-feb-2020       900        GBP

                          .....

                           30-dec-2020      1500       EUR

                           31-dec-2020      1900        GBP

                            30-jan-2021      2200

Best Regards