Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I have a table pulling [PrimaryKey], [Application], [Start Date] and [End Date] values from an existing table.
The rest of the new table is mostly made of calculated columns.
The calculated columns that are causing me grief are as follow:
I edited the formulae to something much simpler, e.g.
CheckDate2 = IF(MultipleEndDateTable[Combo]="1Y", BLANK(), "Checkpoint Date")
This returned accurate results, so it's either something to do with the DATEADD function or the fact that calculations can't be based on other calculations because you can't predict which calculations will take place first.
I guess I should be using something else to get to the desired output. That, or I'm failing to spot an obvious mistake in my formula...
Thanks in advance to whoever can help me with this 🙂
LC
Please read the documentation of the function you're trying to use: https://dax.guide/DATEADD.
@LC_RepAC , Dateadd need the continuous date , in place of that use date like
example
CheckDate1 =
var _1 = MultipleEndDateTable[Start Date].[Date]
return
IF(MultipleEndDateTable[Combo]="1Y", BLANK(),date(year(_1) +1, month(_1), day(_1)))
refer:
https://www.youtube.com/watch?v=YWo-ZpKM6gU
https://www.youtube.com/watch?v=9qiRivlBv8w
User | Count |
---|---|
70 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
24 |