Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

need some help with this DAX

I have two CM "DSKfromlastcyle = VAR _PreviousCycle = SELECTEDVALUE(CC[CycleNum])-1 VAR _DateShiftKetAfter = CALCULATE(MAX(DimCrewSchedule[DateShiftKey]),CC[CycleNum]= _PreviousCycle) RETURN _...
  • hackcrr's avatar
    hackcrr
    2 years ago

    Hi, Anonymous 

    Thank you very much for your reply. You should put this metric and DateShiftKey column in table visual. See if you get the expected results. The metric needs to rely on an external context such as the DateShiftKey column to work.

     

    Best Regards,

    hackcrr

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

Anonymous , Make some changes in second CM 

 

SortingNum =
VAR SelectedDateShiftKey = [DSKfromlastcyle]
RETURN
CALCULATE(
MAX(DimCrewSchedule[SortingNum]),
DimCrewSchedule[DateShiftKey] = SelectedDateShiftKey
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    bhanu_gautam 
    Thanks for helping, I tried the DAX you provided, but it still gives me blank