Custom column for conditions?

[Anmolgan]

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 customer skid) if manufacturer column name is Mahindra then give me 1.

Attach is my sample PBIX file
https://ifitech-my.sharepoint.com/:u:/g/personal/anmol_ganju_ifi_tech/ESBUXLU3H1xPiAO7AXeYgJEBB8WyuX...

[Anonymous · Accepted solution]

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

[Anmolgan]

@Anonymous Thanks for your post, it helped!!

[Ashish_Mathur]

Hi,

That takes me to a log-in page.

[Anonymous]

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.

[parry2k]

@Anmolgan not sure if I understood your question but try adding a column using the following expression and I guess that is what you are looking for, if not then clearly define with example the outcome you want.

Aquisation = 
VAR _min = Sheet1[Min Date] 
VAR _max = CALCULATE ( MAX ( Sheet1[Max Date] ), ALLEXCEPT ( Sheet1, Sheet1[CustomerSKID] ) )
RETURN 
IF ( _max > _min && Sheet1[ManufacturerName] <> "Mahindra", 1, 0 ) 

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡