Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi, I have set in a conditional column to extract a date from one of four columns (all in date format). The conditional column (termed as R-date in my PBI) has also been set to date format. Yet, in filter, under date hierarchy, the year when pulled over shows the years as a random list of 3-digits. Appreciate your advice and help. Thanks.
Solved! Go to Solution.
@PGAT , this does not seem like date or date format
Can you share a sample pbix after removing sensitive data.
@amitchandak, thanks. I am good now. Apparently, a few of my records had a wrong date copied over. All is good now. Thanks for replying.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 50 | |
| 40 | |
| 32 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 87 | |
| 73 | |
| 37 | |
| 28 | |
| 26 |