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: "Total Hours" is a measure which 3 others are table's columns -"weekend date" , "quarter start date" and "quarter end date"
Thanks
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.
6 Replies
- MFelix
Super User
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.
- az38
Community Champion
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) - amitchandak
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output.See if this file can help you. https://www.dropbox.com/s/bu47m5ek7sr9v8t/sales_analytics_v2.pbix?dl=0
v-yuta-msftCommunity Support
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.
