Need a measure

[Anonymous]

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

@az38 

@Greg_Deckler 

[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

[Anonymous]

Hi,

I believe this would be more clear:

weekend date	Quarter Start Date	Quarter End Date	Total Hours	(Required Measure)
2/23/2020	1/6/2020	4/5/2020	140	140
5/20/2020	4/6/2020	7/5/2020	89	89
1/2/2020	4/6/2020	7/5/2020	123	0
6/8/2020	1/6/2020	4/5/2020	88	0
3/12/2020	1/6/2020	4/5/2020	212	212

[v-yuta-msft · Accepted solution]

@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]

@Anonymous 

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

[az38]

@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)

[MFelix]

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.