CODEWITHSUNDEEP
powerbidax
Phani
Phani

Reputation: 5

How to count dates in Power BI DAX

I have a table like below.

enter image description here

I want to show count of LicenseEndDate. Like In my slicer I have taken WeekEnding column suppose if I select weekending date like 09/25/2022 then I want show the count of LicenseEndDate dates that are ended between 09/18/2022 to 09/25/2022. How to create measure for this. I want to show that count in card visual. I created a measure like below

License_Expired_Count = COUNT(Trade[LicenseEndDate]).

But It giving me count of all. That mean the License which are expiring in the feature count also it was showing. But want to show count of license which are expired in the selected period. How create measure for this.

Upvotes: 0

Views: 5513

Answers (2)

Umut K
Umut K

Reputation: 1388

try this :

License_Expired_Count = 
VAR _slt =
    SELECTEDVALUE ( Trade[WeekEndingDate] )
RETURN
    CALCULATE (
        COUNT ( Trade[LicenseEndDate] ),
        ALLSELECTED ( Trade[WeekEndingDate] ),
        DATESBETWEEN ( Trade[LicenseEndDate], _slt - 7, _slt )
    )

check sample file attached

result

Upvotes: 0

Ozan Sen
Ozan Sen

Reputation: 2615

Please check this code, let me know If It works for you.

License_Expired_Count =
CALCULATE (
    COUNT ( Trade[LicenseEndDate] ),
    Trade[LicenseEndDate] <= SELECTEDVALUE ( Trade[WeekEndingDate] ),
    Trade[LicenseEndDate]
        > SELECTEDVALUE ( Trade[WeekEndingDate] ) - 7
)

Upvotes: 0

Related Questions