Forum Discussion

SaaM's avatar
SaaM
Helper II
5 years ago

Equivalent DAX Formula in Power query ?

Hi everybody, It s my first post here.   I am trying to convert a DAX formula in Power Query and so far I have not find the solution   My DAX formula is :         Column = IF( ISBLANK( ...
Need Help
SaaM's avatar
SaaM
Helper II
5 years ago

Thanks for the reply but the solution is not working for me as I have this error at step 3:

The field is a list but i cannot extract it.

Expression.Error: A cyclic reference was detected during the evaluation.

 

And it works with one item only, if you have multiple items it does not work so well, I did not mention that in my question, my bad ....

 

Thanks anyway

Regards

Saam

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi SaaM ,

 

So could you please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business after removing sensitive data?

 

Or as I suggested before, It will be easier to use DAX.

 

Best Regards,
Eyelyn Qin

  • SaaM's avatar
    SaaM
    Helper II
    5 years ago

    Hi Anonymous 

    If I go for the DAX solution can I use it in power query formula ?

    Thanks

    kind regards

    Saam