Forum Discussion
Date problem with formula - LASTDATE
- Anonymous2 years ago
Hi, nor303
The error message "PARAMETER IS NOT THE CORRECT TYPE" usually indicates that the function is receiving an argument of a type that it does not need.In your case, the problem may be with the function. This function requires a string as an argument, but it doesn't seem to be a string. If it's already a date, you don't need to use it.
You can try to modify your DAX expression as follows:Saldo Siste Måned = CALCULATE( SUM('Qlik AGH (2)'[Saldo lån/kreditter]), FILTER( 'Qlik AGH (2)', 'Qlik AGH (2)'[Periode] = MAX('Qlik AGH (2)'[Periode]) && 'Qlik AGH (2)'[LTV] = "LTV" ) )I don't know what this [Saldo lån/kreditter] is, so I'll calculate it according to your existing column [Saldo ] above. I hope this will help you.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ive found this Solution:
However I get a red underline and it says: PARAMETER IS NOT THE CORRECT TYPE.
Can it be something with regional settings or something? And if so how do I correct it?