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
I create some measures with dateadd and I suspect that are some errors on that.
Then I create a calculated columm to see the DATEADD working and prove the problem.
I read some comments about using a date table, but I don´t want to use a date table for some reasons.
Above the table, with the calculated columm and it is possible to see some blank lines.
Solved! Go to Solution.
Hi @guibenassi ,
Without an extra date table, please try below formula:
Vcto Ajustado=DATEADD('Receber E1'[E1_BAIXA2].[DATE];-15;DAY)
Best regards,
Yuliana Gu
Hi @guibenassi ,
Without an extra date table, please try below formula:
Vcto Ajustado=DATEADD('Receber E1'[E1_BAIXA2].[DATE];-15;DAY)
Best regards,
Yuliana Gu
@v-yulgu-msft wrote:Hi @guibenassi ,
Without an extra date table, please try below formula:
Vcto Ajustado=DATEADD('Receber E1'[E1_BAIXA2].[DATE];-15;DAY)
Yes, that will work but note that you must have AutoDate features enabled for this to work. Something I didn't think about because I always have it disabled.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou have to create a Date table. The reason they are returning blanks is the dates that are being calculated don't exist in the column you are using as your source. See this thread for a more comprehensive explanation.
DATEADD() isn't like an Excel function. It relies on a true Date table to work for both calculated columns and measures.
You could do this in Power Query though if you are insistent in not createing a date table. See the Date.AddDays() function there. However, that would create a column and still wouldn't solve your original problem of wanting this in a measure.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingJoin 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 June 2024 Power BI update to learn about new features.
User | Count |
---|---|
138 | |
106 | |
103 | |
74 | |
59 |
User | Count |
---|---|
266 | |
127 | |
119 | |
100 | |
86 |