Forum Discussion
Solved
Conditional Column
Hi There I m new to Power BI and need Dax to achieve the output below. In the dateset i want to add new column output where i want leads from the latest date of same ids and for the earlier d...
Hi, Rajat529 ；
Try this column by dax.
Output2 = var _maxdate= CALCULATE(MAX('Table'[Date]),ALLEXCEPT('Table','Table'[Id])) return IF([Date]=_maxdate,[Leads])The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Rajat529 Try:
Column Output =
VAR __ID = [Id]
VAR __LastDate = MAXX(FILTER('Table',[Id] = __ID),[Date])
RETURN
MAXX(FILTER('Table',[Id] = __ID && [Date] = __LastDate),[Leads])
Hi Greg,
This is very near to the solution but I m not getting blank() in the earlier dates rather i m getting like below
DateMonthNr LeadsIDSlatest_lead
| Monday, September 12, 2022 | September | 56 | 1 | 45 |
| Monday, September 19, 2022 | September | 23 | 1 | 45 |
| Monday, September 26, 2022 | September | 45 | 1 | 45 |
| Monday, October 3, 2022 | October | 21 | 1 | 45 |
| Monday, October 10, 2022 | October | 22 | 1 | 45 |
| Monday, October 17, 2022 | October | 23 | 1 | 45 |
| Thursday, November 24, 2022 | November | 45 | 1 | 45 |
| Monday, September 12, 2022 | September | 56 | 2 | 56 |
| Monday, September 19, 2022 | September | 23 | 2 | 56 |
| Monday, September 26, 2022 | September | 45 | 2 | 56 |
| Monday, October 3, 2022 | October | 21 | 2 | 56 |
| Monday, October 10, 2022 | October | 22 | 2 | 56 |
| Monday, October 17, 2022 | October | 23 | 2 | 56 |
| Thursday, November 24, 2022 | November | 56 | 2 | 56 |
see latest_lead in the last column i m getting through your dax.
can you please update?
Thanks
Rajat