Forum Discussion

KatPL's avatar
KatPL
Frequent Visitor
4 years ago

Populate value for every date using a measure, not a column

Hello, The source data for my model is Analysis Services - SQL server. The model is connected with live connection, which means IT IS NOT possible for me to create columns. I can only create measu...
Need Help
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

Try

Budget Value =
VAR CurrentDate =
    MAX ( 'Date'[Date] )
VAR Result =
    LOOKUPVALUE (
        'Table'[Budget],
        'Table'[Date], DATE ( YEAR ( CurrentDate ), MONTH ( CurrentDate ), 1 )
    )
RETURN
    Result