Calculating Elapsed QTD

Hi jbuzaglu ,

 

Here's my solution.

1.Create a calendar table by dax.

Calendar = ADDCOLUMNS(CALENDAR(DATE(2023,1,1),DATE(2023,12,31)),"Quarter",QUARTER([Date]))

 

2.Create a measure return the percentage.

Elapsed QTD = 
VAR _CALENDAR =
    SUMMARIZE (
        CALENDAR ( DATE ( 2023, 1, 1 ), DATE ( 2023, 12, 31 ) ),
        [Date],
        "Quarter", QUARTER ( [Date] )
    )
VAR _min =
    CALCULATE (
        MIN ( 'Calendar'[Date] ),
        FILTER ( ALL ( 'Calendar' ), [Quarter] = QUARTER ( TODAY () ) )
    )
VAR _MAX =
    CALCULATE (
        MAX ( 'Calendar'[Date] ),
        FILTER ( ALL ( 'Calendar' ), [Quarter] = QUARTER ( TODAY () ) )
    )
VAR _DAYS =
    COUNTROWS ( FILTER ( 'Calendar', [Date] >= _min && [Date] <= _MAX ) )
VAR _DAYS2 =
    COUNTROWS ( FILTER ( 'Calendar', [Date] <= TODAY () && [Date] >= _min ) )
RETURN
    DIVIDE ( _DAYS2, _DAYS )

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.