Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
I need some help with a DAX formula to calculate the length of membership.
I have used the following formula
Active Clients = CALCULATE ([Total Clients]; FILTERS (Clients1; Clients1 [Client: Date Contract Start] <= LASTDATE ('Date uses' [Date]) && (Clients1 [Client: Date Contract End]> = FIRSTDATE (' Date User '[date])))
The problem is that it does not include they who is still a member because there is no date registered in the "Date Contract End" . I expect that I must use IF here in some context, so that if the Date Contrat End is empty then TODAY is selected.
Hope some one can help me with this.