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.
Hi,
I want to display a table with the oldest and most recent dates of each billing.
For example, for my XXX client, I want to see that the first billing took place on 01/01/2020 and the last billing on 07/01/2021.
I therefore created a table with my first invoice date (by selecting "the oldest" in the values "and the name of my customers.
But I can't display the last invoice date.
I tried to make a column like this: colonne = firstdate(factures[dates].[dates]) but it does not work.
If anyone has an idea i will be very grateful.
Thank you by advance.
Alexis
Solved! Go to Solution.
maybe try this
calculate(max(fact[dates]),allexcept(table, FCC_ID))
since the screenshot is not clear, you need to modify the DAX based on your real table and column name.
Proud to be a Super User!
maybe you can try
min(factures[dates])
if you can provide the sample data and expected output , that will be better for us to provide the proper solution
Proud to be a Super User!
Hi @ryan_mayu ,
I tested the formula but it also doesn't work.
This is what I want to achieve (boxed in red, it's a photo montage for the example ) :
So, in my first column I do have my oldest billing date :
I therefore want to concatenate in the same table the oldest date of my invoice and the most recent date.
I hope this will help you ti help me.
maybe try this
calculate(max(fact[dates]),allexcept(table, FCC_ID))
since the screenshot is not clear, you need to modify the DAX based on your real table and column name.
Proud to be a Super User!
Thank you for the response but unfortunatelley it doesn't work
could you pls provide the sample data and expected output?
Proud to be a Super User!
Sorry i just retested and it works, i was the one who made a mistake in the formula. All my excuses.
Thanks for your help
you are welcome
Proud to be a Super User!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |