Forum Discussion
Need help with Table Visualization error in PowerBI desktop
Hi Anonymous
Your measure works well in my test, however I create another measure which could reproduce your issue. Please refer to the following image first and check the difference between them.
The cause is that the dates in 'FITUP INCH DIA' table are not continuous, however dates in 'Dates' Table are continuous. When using 'FITUP INCH DIA'[Date] column in the measure, if the date does not exist in 'FITUP INCH DIA' table, then the reult of LASTDATE() will be blank as well as the DATESINPERIOD(), which makes the measure value blank. However, when using 'Dates'[Date] column in the measure, the date always exist in 'Dates' table so the LASTDATE() and DATESINPERIOD() will not be blank, which makes the measure value not blank.
Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
v-jingzhang : PFA data above for your reference
Hi Anonymous
Your measure works well in my test, however I create another measure which could reproduce your issue. Please refer to the following image first and check the difference between them.
The cause is that the dates in 'FITUP INCH DIA' table are not continuous, however dates in 'Dates' Table are continuous. When using 'FITUP INCH DIA'[Date] column in the measure, if the date does not exist in 'FITUP INCH DIA' table, then the reult of LASTDATE() will be blank as well as the DATESINPERIOD(), which makes the measure value blank. However, when using 'Dates'[Date] column in the measure, the date always exist in 'Dates' table so the LASTDATE() and DATESINPERIOD() will not be blank, which makes the measure value not blank.
Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
Hi v-jingzhang ,
This worked out well for me! Thanks for your time, appreciate it!!
Anonymous You are welcome. Glad it worked!