Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX Measures for Date while using Power BI Dataset

Hi, I am fairly new to Power BI.   I am using a dataset (Power BI dataset) as the source for my new report.  I am trying to create a new measure using data calculations.  Essentially, I have a colu...
DAX
Measures
Power BI dataset
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Based on my test

1. Connect to a Power BI dateset, and create [previousmonth] measure.

2. Create visuals on Power BI Desktop and publish the report to service. Both work fine on my side.

 Did you create visuals firstly in Desktop? Is your Power BI Desktop the latest version?

 

3. It's not supported to apply measures to slicer.

4. When connect to a Power BI dateset , the connection mode is Live connection, we could not create calculated columns in this mode.

 

 

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Thanks for writing!  I succeeded to create the measure.  However, I still get the error when trying to add it to a new visual (table) or existing table (visual).  So unfortunately, I cannot even view the measured data (to confirm it is valid or not).

     

     

    I created this in Power BI Desktop Version: 2.99.621.0 64-bit (November 2021) - I think the latest.

     

    I am new to Power BI.  I am using Live Dataset.  What would the the negative impact if not Live Dataset?

     

    Any thoughts on what this error means?

     

    Thanks!