Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi All
I have a DATE field , it return correct date.
I have create a master calendar table .
I have link sales table with master calendar.
But when i create a table , year field return null value.
Hope some can share with me where go wrong ?
My PBI sample file :-
https://www.dropbox.com/s/6cq0a9lfhyx8711/PBTI_V008.pbix?dl=0
Paul
Solved! Go to Solution.
This is because the date column you have here is text, which means the relationship does not work as expected.
Try redefining the column as VALUE ( SALES_I[AR Invoice Date] ) or
DATE (
RIGHT ( SALES_I[AR Invoice Date], 4 ),
LEFT ( SALES_I[AR Invoice Date], 2 ),
MID ( SALES_I[AR Invoice Date], 4, 2 )
)
and make sure the column type is date or date/time.
This is because the date column you have here is text, which means the relationship does not work as expected.
Try redefining the column as VALUE ( SALES_I[AR Invoice Date] ) or
DATE (
RIGHT ( SALES_I[AR Invoice Date], 4 ),
LEFT ( SALES_I[AR Invoice Date], 2 ),
MID ( SALES_I[AR Invoice Date], 4, 2 )
)
and make sure the column type is date or date/time.
appreciated very much , it work fine.
may i know it is possible to to remove the time stamp ? only display DD/MM/YYYY ? Now it display DD/MM/YYYY 00:00:00
Paul
Set it here:
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 90 | |
| 78 | |
| 66 | |
| 65 |