Forum Discussion

sow0006's avatar
sow0006
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...
Need Help
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity 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's avatar
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'))