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
So whenever I add a measure to a visual, it breaks the visuals and gives me this error " 'DATEADD' expects a contigous selection when the date column is not unique, has gaps or it contains time portion." I already have a date table with each row being the first day of the months from X-Y years, and this date table is related to my other tables. There is no time portion so that is not the issue, I dont think it is due to gaps because I am replicating another PowerBi Desktop version and it uses the same date table perfectly fine. Does anyone know what the problem could be?
@Anonymous , Make sure the date table has all dates and marked as a date table. Marked as a date table . Usally these two things make sure you have a continuous date
if not,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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 |
---|---|
22 | |
20 | |
19 | |
18 | |
13 |
User | Count |
---|---|
41 | |
39 | |
24 | |
22 | |
20 |