Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Good night ! I would like to return as in this example the previous date of the cities. I have no idea how to resolve this issue Thank you !!
@vcaldeira , no column headers, No data in text format. What is the input and output. Nothing is clear.
You can have formula like
maxx(filter(Table, [city] =earlier([city]) && [date] < earlier([date])),[date])
if this did not work
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |