Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 @Anonymous,
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
Hi @Anonymous,
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 @Anonymous,
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 @Anonymous,
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
Hi @Anonymous
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |