Date Cancellation Report =
VAR _Line = 'Outstanding PO Query'[KEY PO LINE]
& IF (
'Outstanding PO Query'[RECURRENCE] > 1,
" - "
& CALCULATE (
MAX ( 'Outstanding PO Query'[Date Cancellation Report] ),
ALL ( 'Outstanding PO Query' ),
'Outstanding PO Query'[KEY PO LINE] = _VAR
Love hearing about Power BI tips, jobs and news? I love to share about these - connect with me!
Thanks for your reply. I am still novice in Power BI and cannot get what I want. I am getting several times the same data in the Concatenate while I would like only 1 data for each cancellation date. This is an example of what I got:
Sorry for my late reply, I was away for a couple of weeks.
I tried out your solutions and I could get the number of recurrences with the COUNTROWS and also get the range MIN-MAX with the report date. However, would it be possible:
- to have the full range of dates displayed (not only MIN & MAX)
- to only display the data that contains the filtered date in the slicer
Otherwise, would it be possible to get this result directly from the table by Grouping by: KEY PO LINE, New column "Count Recurrence" and new column "Concatenate" that concatenates all the cancellation date reports?