cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chateaux83
Helper IV
Helper IV

Struggling with marking a column as date

Dear all,

 

I am struggling with marking a column as date. I get the message 'date column has to includ univocal values' and 'date column cannot inlcude gaps'.

Please see screenshots below, and sorry for the italian 🙂 .

 

The date table I have looks already 'structured' as a date table to me, but I am trying to use it in a quick measure formula (to calculate Month over month change for exampl) and I get the message which says it is not formatted as date - as I read here.

 

Thanks a lot everyone for any hint, I am a bit lost here.

Luca

Inkedsample_LI.jpg

1 ACCEPTED SOLUTION

Thanks again Mariusz,

 

I think that could be the issue. My date data is not on a 'day by day' logic, but I have 2 data points every month (e.g. 01.05.2019, 12.05.2019, 01.06.2019, 15.06.2019.....).

 

Can this be the issue then? In that case, I am afraid I cannot use the quick measure function to calculate e.g. the Month over Month or quarterly trend. Could this be the case, and any way around this?

 

Thank you!


@Mariusz wrote:

Hi @Chateaux83

DAX Time Intelligence functions require Date Dimension to be marked as Date Table due to the logic, if quick measure that you are trying to use happens to contain any of this functions you will be requierd to mark your table.

Please make sure you do not have any duplicate or missing days in between.

 

Hope this helps
Mariusz

 


 

View solution in original post

6 REPLIES 6
Mariusz
Super User II
Super User II

Hi @Chateaux83,

 

You can only mark Date Dimnsion as Date Table, please follow the link to the article that explains how to create one.

Hope this helps
Mariusz

Hi Mariusz, thanks for the reply! What I still don't get is: isn't that I already have a date table/dimension? In fact, PBI recognizes it as such and I can use it to create visuals and so. But when I want to use it in a quick measures formula, somehow it does not work because it is not 'marked' as such. Am i missing something? I assume yes 🙂 Thanks again! Luca

Hi @Chateaux83

DAX Time Intelligence functions require Date Dimension to be marked as Date Table due to the logic, if quick measure that you are trying to use happens to contain any of this functions you will be requierd to mark your table.

Please make sure you do not have any duplicate or missing days in between.

 

Hope this helps
Mariusz

 

Thanks again Mariusz,

 

I think that could be the issue. My date data is not on a 'day by day' logic, but I have 2 data points every month (e.g. 01.05.2019, 12.05.2019, 01.06.2019, 15.06.2019.....).

 

Can this be the issue then? In that case, I am afraid I cannot use the quick measure function to calculate e.g. the Month over Month or quarterly trend. Could this be the case, and any way around this?

 

Thank you!


@Mariusz wrote:

Hi @Chateaux83

DAX Time Intelligence functions require Date Dimension to be marked as Date Table due to the logic, if quick measure that you are trying to use happens to contain any of this functions you will be requierd to mark your table.

Please make sure you do not have any duplicate or missing days in between.

 

Hope this helps
Mariusz

 


 

View solution in original post

Hi @Chateaux83 

 

most probably this is the issue and the solution woud be using the date dimension in the article I've included in my first reply.

 

Hope this helps
Mariusz

Thanks!

 

That helped!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors