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,
I am creating a calculated column using the DAX expression DATEADD(bi_date[Date],-1,YEAR).
For a date key value = 07/01/1999 I see a blank in the calculated column,while for a date 07/01/2000 I get the desired o/p in the calculated column.
What could be the issue?
Regards
Solved! Go to Solution.
Hi @Mystery,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank
Hi @Mystery,
How did you create your date table? As @themistoklis said, Here you should create a date table to make all the necessary dates included in such as.
date = CALENDAR(date(1998,01,01),today())
Regards,
Frank
Hi @Mystery,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank
If in your dataset there are no data for Jan 1998 then the value will be shown as blank for 07/01/1999
For Jan 2000 you see the data because in your dataset you also have data for Jan 1999.
I hope it makes sense
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |