Forum Discussion

merryseeker's avatar
merryseeker
Frequent Visitor
8 years ago
Solved

new column from existing measures

Please see image below.  The last three columns on the right are measures that provide averages by our production day of week based on production date range selected in relative slicer. The figures t...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI merryseeker

     

    Try this MEASURE

     

    AvgbyDOW =
VAR myweek =
    SELECTEDVALUE ( CPwithFuturePullDate[WeekdayNum] )
RETURN
    SWITCH (
        TRUE (),
        myweek = 2, [AvgCrtnsTu],
        myweek = 4, [AvgCrtnsTh],
        [AvgCrtnsSat]
    )
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

When you say new column, you mean new measure correct? The issue I foresee depending on how your measures are calculated is that if you put them into a new calculated column in your table then they are going to be constrained by that row context and I'm thinking perhaps not give you what you are expecting.