Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Goodevening,
One of my formula's (which always worked) just returned an error which i can't explaing.
Roughly translated it states that:
A startdate in the function 'Calendar' may not be past the enddate
I thought someone entered a date which was before (or past) the dates in my 'date' table but even when ive extended the range the error still stayed and im not sure how to correct it.
Can someone help me please ?
Hi,
Can you share your DAX please?
Thanks.
@Anonymous sure thing, should have added it in the first place 🙂
Hi @RonaldvdH ,
You could use a card visual to show the [binnengekomen] and check if it is correct.
@v-eachen-msft the first date for [binnengekomen] is 01-03-2019 and the first date in de 'Date' table is 01-01-2019 so that should be correct right ?
Hi @RonaldvdH ,
Sorry, I didn't make it clear.
Firstly, you need a new measure to show "YourDate" directly.
Measure = if(IsBlank([afgehandeld]); TODAY(); [afgehandeld])
Then you could use two card visuals to show [binnengekomen] and [Measure]. Check if the start date is past the end date.
@v-eachen-msft the measure doesn't work and returns the error that the value for the column 'afgehandeld' cannot be determined. The colum 'Afgehandeld'doesn't excist of there is not a current row for a colum with the name 'afgehandeld'.
I checked both criteria and both are wrong but i can't find the problem
@v-eachen-msft you have any ideas ?
The formula looks fairly straight forward but still returns an error
@v-shex-msft do you have any ideas about this question, its been quiet for a while
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |