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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , if the date column is detected as date the 

new column

month(eomonth([Partner Deal Created Date],-1) )

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago
     
    It looks like when I write this query, the column with dates cannot be selected. It seems only columns with number values are allowed. Not sure why. Thanks
    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      4 years ago

      Anonymous , Hope you are creating a new column, not measure. A column should not stop the selection of a column

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        I am creating measures. The option to create new columns or add tables are not there. I think this is because I am using a power bi dataset as my source.