topic Re: DATEDIFF between DATE column and User SELECT Date in DAX Commands and Tips

DATEDIFF between DATE column and User SELECT Date

JavidRobatian — Tue, 28 Nov 2023 07:19:39 GMT

Hello, I have a very complicated problem. Thank you for your help.
I have two tables in Power BI called Date and Invoice that are related
Now I want to calculate the DateDiff column in the invoice table as follows:
Using the date table and the month column, we create a date filter on the page.
There are two modes
1- The user has not selected the month, in this case:
DateDiff = date[invoice] - today()
Of course, this number must be the smallest number for each customer, for example, for customer number 10
11/28/2023-11/1/2023 =27
2- The user selects the date of the month using the table:
In this case, Today() is equal to the first day of the month selected by the user, and then the DateDiff calculation changes according to the user's selection.

Re: DATEDIFF between DATE column and User SELECT Date

JavidRobatian — Wed, 29 Nov 2023 13:17:00 GMT

If the explanation is not clear, please tell me so that I can explain more.

Re: DATEDIFF between DATE column and User SELECT Date

Dangar332 — Thu, 30 Nov 2023 07:09:54 GMT

hi, JavidRobatian

try below code

Measure = var a = SELECTEDVALUE('date'[month]) var b = DATEDIFF(CALCULATE(min(invoice[date]),ALLEXCEPT(invoice,invoice[cu nu])),TODAY(),DAY) var c = DATEDIFF(CALCULATE(min(invoice[date]),ALLEXCEPT(invoice,invoice[cu nu])),DATE(2023,a,1),DAY) var d = IF(ISFILTERED('date'[month]),c,b) return d