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