Forum Discussion

abdul26's avatar
abdul26
Frequent Visitor
3 years ago
Solved

Add a constant column

I have created a marix with the following details    Rows: Company name  Columns:   Week numbers  Values - Values    I wish to add a constant value threshold column. But if a create a measure w...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    Assuming the figures under the Week column are derived via a measure (called Measure1), write this measure

    Measure = if(hasonevalue(Data[Week]),[Measure1],30)

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Assuming the figures under the Week column are derived via a measure (called Measure1), write this measure

Measure = if(hasonevalue(Data[Week]),[Measure1],30)

Hope this helps.