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]
    )
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

HI merryseeker

 

Try this MEASURE

 

AvgbyDOW =
VAR myweek =
    SELECTEDVALUE ( CPwithFuturePullDate[WeekdayNum] )
RETURN
    SWITCH (
        TRUE (),
        myweek = 2, [AvgCrtnsTu],
        myweek = 4, [AvgCrtnsTh],
        [AvgCrtnsSat]
    )
  • merryseeker's avatar
    merryseeker
    Frequent Visitor
    8 years ago

    Thanks so much Zubair_Muhammad! This worked after I deactivated a relationship that I apparently did not need to have active.