Forum Discussion

danielpaduck's avatar
danielpaduck
Helper III
2 years ago

Calculate Question - How To Keep A Column Value In The Calculation

Hi,   How is it possible to keep/evaulate the column 'Period'      In my Calculate function?   Labor Hours Conditional (D) = var minPeriod = CFGDates_Min_Max[Min Period (msr)] var ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

The approach should be as follows:

  1. Create a Calendar Table with calculated column formula for Year, Month name and Month number.  Sort the Month name column by the Month number column
  2. Create a relationship (Many to One and Single) from the Date column of your Data Table to the Date column of the Calendar Table
  3. To yoru visual, drag Year and Month name from the Calendar Table
  4. Write this measure

Measure = if(month(min(calendar[date]))=1,[Actual],[Forecast])

Hope this helps.

  • danielpaduck's avatar
    danielpaduck
    Helper III
    2 years ago

    I will try ths.