Forum Discussion

Ronald123's avatar
Ronald123
Resolver III
5 years ago
Solved

Dynamic calculation workingsdays

Hello,   I need a measure to calculate the workingsdays dynamic based on a condition. This condition is based on a slicer.  Please take a look @ the test file with the expected results. Gree...
Need Help
Ronald123's avatar
Ronald123
Resolver III
5 years ago

Helle Pragati11 ,

I got stuck on the dynamic END DATE based on the slicer [disconnected table].
Could you take a look @ the Test file?

Greets,

 

Ronald

  • Ronald123's avatar
    Ronald123
    Resolver III
    5 years ago

    Pragati11 

    My bad, i don't know how to implement below condition in the code from the blog.
    Could you help me to make the measure in the test file?

    Greets,

    Ronald

     

    Variable condition

     

    END DATE IF ( Date Slicer < END DATE then SLICER else END DATE

    • Pragati11's avatar
      Pragati11
      Super User
      5 years ago

      Hi Ronald123 ,

       

      Apologies for not responding earlier as somehow I didn't get a notification for your above response.

      Were you able to resolve the issue?

       

      Thanks,

      Pragati

      • Ronald123's avatar
        Ronald123
        Resolver III
        5 years ago

        Hi Pragati11 ,

        My way of thinking was wrong, thanks for put me on the right track.

        Greets,

        Ronald