Forum Discussion
Solved
Calculated column help needed
Hello all, I am facing an issue to get the required column as shown using DAX. Please help how to get the required column in DAX. Thanks, Sam
- what I understood from all this is, pick first value from FoecastedAllocation column where the WeekStartingDate is same as MonthlyDate
so here it is,
= IF(Data[WeekStartingDate]=Data[MonthlyDate],FIRSTNONBLANK(Data[FoecastedAllocation],Data[WeekStartingDate]=Data[MonthlyDate]),BLANK())
still don't get it, on what basis is the fourth column - why does it contains values for few rows and why other empty.?
Hi,
I need to show the 4th column values in a graph without summing up all the data for 04/23/2018. I just need to have the first value 80 for the date 04/23/2018 and I need to get the 100 for the date 5/21/2018 and so on based on MonthlyDate column.
Please let me know if you need any more info.
Thanks.
- what I understood from all this is, pick first value from FoecastedAllocation column where the WeekStartingDate is same as MonthlyDate
so here it is,
= IF(Data[WeekStartingDate]=Data[MonthlyDate],FIRSTNONBLANK(Data[FoecastedAllocation],Data[WeekStartingDate]=Data[MonthlyDate]),BLANK())