Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone.
I'm facing an issue and you may help me with that.
As you will see in the table below, I have four columns : invoice_number, invoice_date, customer_number, customer_machine_number.
The customer_machine number is a nullable column.
I notice that when I make a search the last date of the column invoice_date in this table, if the customer_number is not null and the customer_machine_number is null, I find one last date.
But if the customer_number and the customer_machine_number are both not null, I find another last date.
I would like to show the two different last date in a matrice table but I don't know how to do it.
Anyone ?
invoice_number | customer_number | customer_machine_number | invoice_date |
7876875 | 123456 | 123678 | 1/1/2021 |
7786875 | 123456 | 1/1/2021 | |
7096875 | 123456 | 123678 | 1/1/2021 |
7456875 | 123456 | 1/1/2021 | |
7026875 | 123456 | 1/1/2021 | |
7946875 | 123456 | 123678 | 2/1/2021 |
7086875 | 123456 | 1/1/2021 | |
7879105 | 123456 | 123678 | 2/1/2021 |
7870375 | 123456 | 1/1/2021 | |
7870R15 | 123456 | 1/1/2021 | |
78015Z5 | 123456 | 123678 | 2/1/2021 |
invoice_number | customer_number | customer_machine_number | last_date(invoice_date) |
78015Q5 | 123456 | 123678 | 2/1/2021 |
invoice_number | customer_number | customer_machine_number | last_date(invoice_date) |
78015Q5 | 123456 | 1/1/2021 |
Solved! Go to Solution.
I finally solve the problem with this measure :
I finally solve the problem with this measure :
measure 1 = // where machine and customer number not null
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
Hello !
Thank for your help, but this measures doesn't work...
I found the good date for the measure 2 but not for the measure 1
try max in place MIN hope this will give you the output
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
I've already try that with MAX!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |