Forum Discussion
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:...
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.
Hi Anonymous ,
Please see this post regarding How to Get Your Question Answered Quickly (courtesy of @Greg_Deckler) and How to provide sample data in the Power BI Forum (courtesy of @ImkeF).
Without example data is difficult to give you a better help.
If you can share a sample data (especially on the dates columns) and if you are using a calendar table or dates within your data table would be helpfull to assist you.