Power Query

[Yashodhan]

Having Issue with this query,what will be the right Solution ? please Suggest

[amitchandak · Accepted solution]

@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/

[v-eqin-msft · Accepted solution]

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:

• Use DAX: Add a Column

Column(DAX) = IF(ISBLANK(RELATED(TABLE2[Monthly BRAESN])) && ISBLANK( RELATED(TABLE2[Monthly ESN] )),"New","Old")

• In Power Query: Merge two tables and Expand columns-->Add a custom column-->Remove unnecessary columns

=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.

[amitchandak · Accepted solution]

@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/