Forum Discussion

nor303's avatar
nor303
Helper III
2 years ago
Solved

Date problem with formula - LASTDATE

Hi   This problem is driving me nuts, everything seems to be in order but the formula wont work. Ive tried different formats, checked options etc. Nothing helps. Anyone have an idea why the measure...
  • Anonymous's avatar
    Anonymous
    2 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.