Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DAX Max Consecutive days run in Date Range Selected

HI Guys, after some DAX help in solving a problem I have. Basically its a table of dates and results and targets.   I need to get the maximum consecutive days that Targets have been met in the se...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Ya,

    thanks so much for the lead,

     

    had a good look at their solution but that work for me as Im in Direct Query mode and 'calculate' isnt allowed in calculated columns so cannot even create the first column. Ended up putting the index into a SQL view to try and work that problem , but no luck.

    Still looking at community pages for other solutions.

     

    Mike.