Forum Discussion

Frequent Visitor

4 years ago

Use clause Where in Dax

Hello, I want to reproduce the formula below in a column calculated in PBI : WHERE ((datedemand between '20210201' and '20220530') or (qte<>qtelivree and datedemande >= to_date('20210201','YYYY...

Icon for Resolver II rank

Resolver II

4 years ago

Column = CALCULATE('Table'[Column],AND('Table'[datedemand] >= 20220530,'Table'[datedemand] <= 202205))

Try this! Or this:

Column = CALCULATE('Table'[Column],DATESBETWEEN(<dates>, <start_date>, <end_date>))

sow0006
Frequent Visitor
4 years ago
thank you for your answer but datedemand between '20210201' and '20220530' is used from a segment so the problem is how implemented or (qte<>qtelivree and datedemande >= to_date('20210201','YYYYMMDD') - interval '3 month' and requestdate <= '20220530');

I tried this:
Mesure 2 = CALCULATE( nouvelleMesure[Mesure], OR( DATESINPERIOD('Table'[datedemande], MAX('Table'[datedemande]), -3,MONTH), [qte moins qtelivree]<>0) )
but it does not work
- v-zhangti
  Community Support
  4 years ago
  Hi, sow0006
  
  Can you explain the meaning of the statement again?
  
  WHERE ((datedemand between '20210201' and '20220530') or (qte<>qtelivree and datedemande >= to_date('20210201','YYYYMMDD') - interval '3 month' and datedemande <= '20220530'))
  
  What do you expect the output to look like? Can you show it in a picture?
  
  Best Regards,
  
  Community Support Team _Charlotte
  
  If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  - sow0006
    Frequent Visitor
    4 years ago
    Hi v-zhangti
    
    The request is to calculate the delivery delays and the output is to have the number of hours expected.
    SELECT SUM(hprevues)/360000 AS totalhp FROM plannifoperateur WHERE ((datedemand between '20210201' and '20220530') or (qte<>qtelivree and datedemande >= to_date('20210201','YYYYMMDD') - interval '3 month' and datedemande <= '20220530'))

Related content