Forum Discussion

Administrator

2 years ago

Counting Between Dates

Good day, I'm new to power bi and I'm having problems with a formula that at first glance seems simple. I have already seen other similar posts in this forum, but I have not found a response. I have...

Anonymous

Not applicable

2 years ago

Hi, Syndicate_Admin

Based on your information, I create a sample table:

Then create a new measure and try the following DAX expression:

Historical Assets = 
VAR MinYear = YEAR(MIN('Table'[Start Date]))
VAR MaxYear = YEAR(MAX('Table'[End Date]))
RETURN
SUMX(
    GENERATESERIES(MinYear, MaxYear, 1),
    VAR CurrentYear = [Value]
    RETURN
    CALCULATE(
        COUNTROWS('Table'),
        'Table'[Start Date] <= DATE(CurrentYear, 12, 31) &&
        'Table'[End Date] >= DATE(CurrentYear, 1, 1)
    )
)

Here is my preview: