Forum Discussion

ThomasWeppler's avatar
ThomasWeppler
Icon for Impactful Individual rankImpactful Individual
3 years ago
Solved

Selected a date every x months

Hi Power BI community   I have a table with five columns   1. Index: An index column 2. Assignment: A Number column that shows diffrent assignment. (In this example we will just look at [Assignm...
Need Help
  • grazitti_sapna's avatar
    grazitti_sapna
    3 years ago

    Hi ThomasWeppler 

    You can try using 

    Flag =
    IF (
        [Assignment] = 1
            && (
                [Date] = [Firstdate]
                || (
                    [Date] = EDATE ( [Firstdate], INT ( MID ( [Interval], 1, FIND ( "month", [Interval] ) - 1 ) ) )
                        && DAY ( [Firstdate] ) <= DAY ( [Date] )
                )
            ),
        1,
        0
    )

     

    Thank you. Hope this will help

grazitti_sapna's avatar
grazitti_sapna
Icon for Super User rankSuper User
3 years ago

Hi ThomasWeppler 

You can try using 

Flag =
IF (
    [Assignment] = 1
        && (
            [Date] = [Firstdate]
            || (
                [Date] = EDATE ( [Firstdate], INT ( MID ( [Interval], 1, FIND ( "month", [Interval] ) - 1 ) ) )
                    && DAY ( [Firstdate] ) <= DAY ( [Date] )
            )
        ),
    1,
    0
)

 

Thank you. Hope this will help