how to setup a baseline value to compare against row values?

[Anonymous]

hi all,

Im trying to creat a baseline value to use  in a matrix table that compares to a daily forecast.

In this table the base line value is loaded on date 3/20/2020 and the rest are the following days values which i want to see the change in units against the base line value

since im using to date table(one for X axis and another for the load of the forecast in Y axis) i used the following dax messure to try and ignore the dates on the left and have it repeat the baseline number but i end up just having one entry in the date 3-20-20

little bit of context the table ref calendar is the one used in the Y axis or  row dates. 

I belive this can bee solve using variables but not sure hoe to implement it

thanks for  the help

[Anonymous]

Hi @Anonymous ,

Could you please provide some smaple data in source table "Demand Plans"(exclude sensitive data)? And which table the fields applied on Matrix are from?

Best Regards

Rena

[Greg_Deckler]

Why not:

CALCULATE(SUM('Demand Plans'[DP Qty]),'Ref Calendar'[Date] = DATE(2020,3,20))

[Anonymous]

Seems to work,

however the baseline date is hardcoded, how can i call it dynamically, say havin another table to use in a slicer with the baseline date to use? how would that be implemeted in the calculate function?

[Anonymous]

Hi @Anonymous ,

Can I know how to get these Baseline DP QTY with red circle which displayed in below sceeen shot? If you want to dynamically obtain this base date, then there are bound to be any rules or conditions here. Is there such a rule?

Which tables the fields applied on matrix are from? Could you please provide some sample data in source tables? And if they are from multiple tables, please provide the relationship and bond field between 2 tables. Thank you.

Best Regards

Rena