Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Problem with Dates on DAXE

Hi experts,

 

I have a problem operating dates

 

I have used this formula to convert a Julian date to Calendar Dates

Date = DATE(INT(F60[DATE01]/1000)+1900,1,MOD(F60[DSDATE01],1000))
 
It seems to work as you can see in the following picture.
 
 
However, I am not able to create a hierarchy that breaks the date in days, month and year. Below what I want to get
 
 
I also need to calculate the number of days of the current and previous month. But, when I tried to use a new measure using the EOMONTH formula I got the following message: 
 
"A single value for column 'Date' in table 'F60' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."
 
Do you have any idea how can I solve those problems?
 
I would appreciate any help you can give me.
 
Thanks :smileyhappy:
 
 
 
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    7 years ago

    Hi Anonymous ,

     

    You need to select the table "F59DBTSM" and then add the column, you can check your filed whether the calculated column added in the specific table. if you add it in other place, the error "A single value for column..." occured.

     

2 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    7 years ago

    Hi Anonymous ,

     

    You need to select the table "F59DBTSM" and then add the column, you can check your filed whether the calculated column added in the specific table. if you add it in other place, the error "A single value for column..." occured.