Forum Discussion

sam021083's avatar
sam021083
Frequent Visitor
8 years ago
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
Need Help
  • iamprajot's avatar
    iamprajot
    8 years ago
    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())
sam021083's avatar
sam021083
Frequent Visitor
8 years ago

Hi,

 

I have first 3 columns in my table. I need to have a calculated column in the format of required column mentioned in the picture using DAX.

 

Thanks

iamprajot's avatar
iamprajot
Icon for Responsive Resident rankResponsive Resident
8 years ago
still don't get it, on what basis is the fourth column - why does it contains values for few rows and why other empty.?