Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
@Yashodhan , This DAX is not power Query. In Power Query you need to merge data to get a column from another table
refer if needed
https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/
Hi @Yashodhan ,
M Language and DAX are supported by Power BI to manage, manipulate, filter, and analyze the data. but they are not the same and not dependent upon each other and each one has different syntax, structure, and logic.
Based on your screenshot, it seems that you want to set a flag column based on a related column from two tables.
If so, I have built a data sample as shown below:
Please try:
Column(DAX) = IF(ISBLANK(RELATED(TABLE2[Monthly BRAESN])) && ISBLANK( RELATED(TABLE2[Monthly ESN] )),"New","Old")
=if [Monthly BRAESN] is null and [Monthly ESN] is null then "New" else "Old"
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.
Hi @Yashodhan ,
M Language and DAX are supported by Power BI to manage, manipulate, filter, and analyze the data. but they are not the same and not dependent upon each other and each one has different syntax, structure, and logic.
Based on your screenshot, it seems that you want to set a flag column based on a related column from two tables.
If so, I have built a data sample as shown below:
Please try:
Column(DAX) = IF(ISBLANK(RELATED(TABLE2[Monthly BRAESN])) && ISBLANK( RELATED(TABLE2[Monthly ESN] )),"New","Old")
=if [Monthly BRAESN] is null and [Monthly ESN] is null then "New" else "Old"
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.
@Yashodhan , This DAX is not power Query. In Power Query you need to merge data to get a column from another table
refer if needed
https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.