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 ,

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 .