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.
Hi 🙂
Can anyone help me why all my data is not showing in Power BI?
I have added a new coloum named "LCI 2" with the following formula:
LCI 2 = DATEADD('TMI (Index)'[Comm pkg.Planned startup];-84;DAY)
But the results are not showing in all the cells in this column. Does any one now why?
I understand why its blank in cells that are blank, but i dont understand it where i already have a date.
Thank you in advance.
Best regards
Marte
Solved! Go to Solution.
Hi mhoff,
"The result table includes only dates that exist in the dates column"... [Comm pkg.Planned startup] in your case.
See Function explanation.
https://docs.microsoft.com/es-es/dax/dateadd-function-dax
Hi @mhoff,
The reply of Miltinho should be useful.
In addition, if you want to show the date of the 84 days before the 'TMI (Index)'[Comm pkg.Planned startup], you could create another calendar table with CALENDARAUTO fucntion or CALENDAR function, then create the relationship with the tables.
Then you could create the calculated column with the formula below.
Column = DATEADD('calendar'[Date],-2,DAY)
Here is my test example.
If you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Hi @mhoff,
The reply of Miltinho should be useful.
In addition, if you want to show the date of the 84 days before the 'TMI (Index)'[Comm pkg.Planned startup], you could create another calendar table with CALENDARAUTO fucntion or CALENDAR function, then create the relationship with the tables.
Then you could create the calculated column with the formula below.
Column = DATEADD('calendar'[Date],-2,DAY)
Here is my test example.
If you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Hi mhoff,
"The result table includes only dates that exist in the dates column"... [Comm pkg.Planned startup] in your case.
See Function explanation.
https://docs.microsoft.com/es-es/dax/dateadd-function-dax
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |