The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All,
I'm trying to create a calculated column based on some specific criteria.
So i have a list of LCV registration numbers and i want to identify which ones still have an mot. So the column should be: vehicles[vehicle_has_MOT). I want to see "1" when the vehicle has the MOT product, and "0" when it doesn't.
MOT is a parent product in the same table, and has the three sub products in a separate column:
Reg Product Product Type Policy Count (we use 1 or 0) CALC_COLUMN
ABC MOT Single Payment 1
ABC MOT Monthly Payment 0
ABC MOT FOC 0
I want the CALC_COLUMN to do something like vehicles_[has_MOT]=1
apologies if this is obvious, i'm new to Power BI 🙂
Solved! Go to Solution.
Hi @James__
Can you please try this DAX for calculated column
CALC_COLUMN = IF( Product = "MOT", 1, 0 )
Paste it in the new column.
Accept it as a solution if its help you to solve your problem.
@James__
In your example,
Reg Product Product Type Policy Count (we use 1 or 0) CALC_COLUMN
ABC MOT Single Payment 1
ABC MOT Monthly Payment 0
ABC MOT FOC 0
2nd and 3rd line has product MOT, but why you are showing 0 inplace of 1
Please confirm
Hello @PijushRoy
The MOT has 3 separate products: Single payment, monthly payment and FOC. In the example above, this particular van has a single payment MOT product, and not monthly payment or FOC.
Hope that helps.
J
Hi @James__
Can you please try this DAX for calculated column
Sorry, that didn't work 🤔
Hi there!
You can try this:
IF( Product = "MOT", 1, 0 )
Let me know if that helps!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
112 | |
69 | |
46 | |
43 |
User | Count |
---|---|
186 | |
85 | |
76 | |
74 | |
56 |