Multiple date fields - use selected value to get insights

DAX DAX Calculations
1

My dataset has multiple dates. Car shipped, delivered, registered.
I want to allow the user to select a date (from a master date table) and from that it will tell them how many cars were purchased before that date and how many cars were purchased after that date as one total.

I’ve been using “selected value” and trying to make it work by activating the inactive relationship. But I can’t get it to work?

Multiple Date Fields in the same file.pbix (24.8 KB)

2

Hi @chad.sharpe - Based on the requirement mentioned in the PBIX file, try using below measure. Also, this can be modified as per requirement.

TotalCnt = var SelDate = SELECTEDVALUE('Calendar Date'[Date])

var PurchaseDateCnt = CALCULATE(COUNTROWS('Car Table'),all('Calendar Date'),'Car Table'[Purchase Date] < SelDate)

var DeleiveryDateCnt = CALCULATE(COUNTROWS('Car Table'),all('Calendar Date'),'Car Table'[Delivery Date] > SelDate)

return

PurchaseDateCnt + DeleiveryDateCnt

Thanks
Ankit J

2 Likes
3

It’s so simply… I clearly made it more difficult than it needed to be… lol
Thanks…