Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need a measure

Hi, I have to calculate a measure which should be based on the following logic:   if "weekend date" = in between ("quarter start date" and "quarter end date") then "Total Hours" else "0"   Note:...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Anonymous ,

     

    Create a measure using dax as below:

    Result = IF(MAX('Table'[weekend date]) >= MAX('Table'[Quarter Start Date]) && MAX('Table'[weekend date]) <= MAX('Table'[Quarter End Date]), MAX('Table'[Total Hours]), 0)

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

az38's avatar
az38
Community Champion
6 years ago

Anonymous 

will it help a simple statement like

Measure=
IF(Table[weekend date] >= Table[quarter start date] && Table[weekend date] <= Table[quarter end date], Table[TotalTime], 0)