Calculate Month from Number of Days

[sam245gonsalves]

Hello,

I have a column in the dataset that specifies the number of days(num_ofDays) which is of the type integer.

I'm trying to create a new column called month that lets me determine the month based on number of days.

The formula I'm trying to use is Ceiling(num_ofDays/30.5, 1)

Using this formula causes Power BI to throw an error & hangup & lose all progress on reports. The error Im getting is 

Unable to cast object of type System.Decimal to System.char

I tried replacing Ceiling with Round & Integer & they work just fine except that I'm not really getting the correct numbers.

Is there anything I'm missing?

Thanks,

Samantha

[v-alq-msft]

Hi, @sam245gonsalves 

You may try the following calculated column to see if it works.

M = ROUNDUP([NumOfDays]/30.5,0)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy · Accepted solution]

@sam245gonsalves 

This could be a data conversion issue, check your data source and the data types of the columns try to do it on a small sample of your data.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[sam245gonsalves]

Hey @Fowmy 

Thanks, I tried the above but it still causes the entire application window to freeze

I tried the roundup function as well - with the same results.

[Fowmy]

@sam245gonsalves 

It should work, try the fully qualified column name

New Column = Ceiling(Table[num_ofDays]/30.5, 1)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn