Forum Discussion

KatPL's avatar
KatPL
Frequent Visitor
3 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
3 years ago

If Date is filtering budget then you can probably use a simple MAX('Budget'[Budget value]) and rely on the date from the visual to filter it appropriately.

KatPL's avatar
KatPL
Frequent Visitor
3 years ago

Unfoturantely this also does not work - on a chart this measure still gives me Budget value only for 1st of the month as a one blue point, instead of a blue line with the same value for every day:

 

BUD Value = MAX(Budget[Budget Value])
 

 

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    Try

    BUD Value =
CALCULATE ( MAX ( 'Budget table'[BUD Value] ), STARTOFMONTH ( 'Date'[Date] ) )