Forum Discussion

Anmolgan's avatar
Anmolgan
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Custom column for conditions?

How can I write below condition as per below screenshot:     I want to write on below in a customerskid if on any customer skid,  max date> min date and on whatever max date (of that custom...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anmolgan ,

     

    Could you tell me if my post helps you a little? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.


    Hope to hear from you‌‌😀


    Best Regards,
    Eyelyn Qin

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anmolgan ,

 

Sorry for that the information you have provided is not making the problem clear to me.

 

If you want to get the maximum max date based on multiple selected CustomerSKIDs, since it will be dynamically changed by your selections in slicer, so please try to use the following formula to create a measure:

Measure = 
VAR _min =
    MIN ( 'Sheet1'[Min Date] )
VAR _max =
    CALCULATE ( MAX ( 'Sheet1'[Max Date] ), ALLSELECTED ( Sheet1 ) )
RETURN
    IF ( _max > _min && MAX ( 'Sheet1'[ManufacturerName] ) <> "Mahindra", 1, 0 )

 

If not, please describe what you expected in detail and provide the output to help us clarify your scenario.

 

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