How to Get Your Question Answered Quickly

Hi,

Quite new in this forum as well as with the PowerBI platform, and I would appreciate your help.

I created one line chart with to data sets (lines) that is using excel as data input. Data are well transformed, I believe. Problem is that one of the lines I would need to limit modify the syntax so it limits the dates by today only.

Here is the original syntax:

PLANNED_APPROVAL_CHART_measure running total in Date =

CALCULATE(

    [PLANNED_APPROVAL_CHART_WORST_measure],

    FILTER(

        ALL('AAA_DIM_DATE_CHARTLINE'[Date]),

        ISONORAFTER('AAA_DIM_DATE_CHARTLINE'[Date], MAX('AAA_DIM_DATE_CHARTLINE'[Date]), DESC)

    )

)

I have try to use a help of "favourite" chatGPT; nevertheless, their suggested:

PLANNED_APPROVAL_CHART_measure running total in Date = CALCULATE( [PLANNED_APPROVAL_CHART_WORST_measure], FILTER( ALL('AAA_DIM_DATE_CHARTLINE'[Date]), 'AAA_DIM_DATE_CHARTLINE'[Date] <= TODAY() ) )

 

Unfortunately, it does not work and turns into this, please, check the prtscr (when I applied the chatGPT's syntax the light blue line (PLANNED_APPROVALS), which I need to modify, turns into this 😞

 

 

Any suggestions, please?

Tom