Forum Discussion

mark_carlisle's avatar
mark_carlisle
Advocate IV
2 years ago

cell magic %%dax returning error

I have a notebook thats using Semantic Link to get data from a Power BI semantic model. I am able to successfully access data using fabric.evaluate_measure, however the limitation of the filter only ...
data engineering
Data Integration
Fundamentals
one lake
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi mark_carlisle ,

Thanks for using Fabric Community. 
Let me check and try to find out if there is any syntax issue with your code.

  • mark_carlisle's avatar
    mark_carlisle
    Advocate IV
    2 years ago

    Hi Anonymous - any progress we're still trying but with no success.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi mark_carlisle ,

      I can find some issue with your syntax, would like to understand what you are trying to do.

      As I understand you are trying to apply filters greater than particular date.

      For that you can try to use syntax - For eg:

       

       

      import sempy.fabric as fabric

df_dax = fabric.evaluate_dax(
    "Customer Profitability Sample",
    """
    EVALUATE SUMMARIZECOLUMNS(
        'State'[Region],
        'Calendar'[Year],
        'Calendar'[Month],
        'State'[State],
        FILTER('Calendar', 'Calendar'[Year] >= 2009 && 'Calendar'[Year] <= 2011),
        )
    """)

df_dax

       


      Inorder to get some idea please refer below link,
      Read data from semantic models and write data that semantic models can consume - Microsoft Fabric | Microsoft Learn
      FILTER function (DAX) - DAX | Microsoft Learn

      Hope this is helpful. Please let me know incase of further queries.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi mark_carlisle ,

        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
        In case if you have any resolution please do share that same with the community as it can be helpful to others .
        Otherwise, will respond back with the more details and we will try to help .