The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi
I'm using the "DATEADD" function in my report, and it works perfectly, until i start to DrillDown in my sharts.
i get this Error :" Error in the calculated mesure 'Data'[Mois - mois-1] : the DATEADD function expects a continous selection when the date column is not unique, or not continous or contains hours".
But my date column has continous dates :
I even created another date table, but it doesn't work.
Here is the shart that shows me errors when i DrillDown with " Type d'article"
I get that Error only when i get to the last level in the hierachy.
And here is my two formulas, that contains "DATEADD".
here is the link to my Power BI file :
https://drive.google.com/open?id=1ZknrfWAoECPKoS9kmnZ56vg5A18GP_cU
Hello @Ghaston,
Column used in the DATEADD function in measure Mois - (mois-1) refers to 'Echelle de temps' which doesn't have continuous dates.
For that you must create a dimension date table with continuous dates and set the relationship with column Echelle de temps.
Hope this helps.
There is a picture in my message showing the " Echelle de temps" data. Why that isn't continous ? it doesn"t skip any month since decembre 2017.
I created a date table, that starts from MIN of "Echelle de temps" and ends at MAX "Echelle de temps", and that gave me the same " Echelle de temps " column.
Hello @Ghaston,
It should contain series of dates from 1st to 30/31st. Column of such dates are known as "contiguous dates".
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
119 | |
87 | |
75 | |
55 | |
44 |
User | Count |
---|---|
135 | |
125 | |
78 | |
64 | |
63 |