Forum Discussion

Sylvine_Wyz's avatar
Sylvine_Wyz
Icon for Helper IV rankHelper IV
1 year ago
Solved

Table dynamic filter complex

Hello EveryBody, I have a complex request that I can't resolve. Can you help me please ?  I give you an extract of my data set. I would like to have a solution that allows the calculated colu...
Need Help
Tutorial Requests
  • lbendlin's avatar
    lbendlin
    1 year ago
    that allows the calculated column Group_recap_Date to evolve according to the Invoice Date chosen by the user in the report filter

    You cannot create calculated columns based on user filter choices.

Sergii24's avatar
Sergii24
Icon for Super User rankSuper User
1 year ago

Hi Sylvine_Wyz, I'm not sure I fully undertood what you're asking for, however please find below the general structure for your measure:

Measure = 
VAR _MinDate = MIN( 'Table'[Date] )     //capture the minimum date for the current filter context
VAR _Result =
    CALCULATE(
        SUM( 'Table'[HSTS_OKAY] ),      //replace with your expression
        'Table'[Date] <= _MinDate       //exclude any invoices received after this date
    )


If you want more specific help, please send a sample of table(s) to work with, and the example of desired output for a specific case (with step-by-step) explanation of the logic. Sample pbix would be the best! 🙂