Forum Discussion

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

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())

8 Replies

iamprajot
Responsive Resident
8 years ago
I do not understand what needs to be done here.
On what basis are you trying to get the required value, explain your issue properly.
- 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
    Responsive 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.?
Tatynout
Frequent Visitor
8 years ago
hello sam021083,

Can you please give more details about what is it you trying to do?

Regards,
Tatiana Nouteping