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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

hackcrr 

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

hackcrr's avatar
hackcrr
Icon for Memorable Member rankMemorable Member
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.