Forum Discussion

CSmith_HW's avatar
CSmith_HW
Frequent Visitor
5 years ago
Solved

DAX Help! Return date that cumulative total surpassed a column value

Hi guys,   I have a campaign table that look like the below:   Campaign ID Target Price 1 £50,000 2 £70,000 3 £120,000 4 £35,000   and a table of deals that looks like: ...
  • rfigtree's avatar
    5 years ago

    hi i have a problem understanding context transition but i think this works.

    probably a much neater way of doing it.

    had to fiddle your data as none of the targets met as you put them.