Forum Discussion
Post ProdigyMeasure is not showing total value
This is my formula
Jan 2020 measure =
var a = IF(MONTH(MAX(Operation[Budget 2020 Start Date]))<=1, 31*VALUE(Operation[Daily Budget measure]), BLANK())
RETURN
IF(YEAR(MAX(Operation[First_COD__c]))<>2020,
a,
IF(MONTH(MAX(Operation[Budget 2020 Start Date]))<=1, IF(MONTH(MAX(Operation[Budget 2020 Start Date]))=1,DATEDIFF(MAX(Operation[Budget 2020 Start Date])-1,DATE(2020,1,31),DAY)*VALUE(Operation[Daily Budget measure]), a)))
The above measure is not showing any total as seen below. How do I fix it?
@parry2k @mahoney19 @parry2k @az38 @jdbuchanan71 @mahoneypat @edhans @harshnathani @v-kellya-msft @MFelix @Ashish_Mathur @BA_Pete @ryan_mayu @kbuckvol @Alexander76877 @Petazo @Mariusz @TomMartens @Greg_Deckler @tjd @Sean @mikstra @AllisonKennedy @EricHulshof @briandpeterson @USG_Phil @vpatel55 @mwegener @v-piga-msft @tex628 @sturlaws @Vvelarde @CheenuSing @MarcelBeug @Zubair_Muhammad @v-piga-msft @danextian @MattAL @MattAllington @roalexan @Alexander76877 @kgc
3 Replies
- amitchandak
Super User
Kolumam , Try like
var a = IF(MONTH(MAX(Operation[Budget 2020 Start Date]))<=1, SUMX(VALUES(Operation),31*Operation[Daily Budget measure]), BLANK()) RETURN SUMX(VALUES(Operation) ,IF(YEAR(MAX(Operation[First_COD__c]))<>2020, a, IF(MONTH(MAX(Operation[Budget 2020 Start Date]))<=1, IF(MONTH(MAX(Operation[Budget 2020 Start Date]))=1,DATEDIFF(MAX(Operation[Budget 2020 Start Date])-1,DATE(2020,1,31),DAY)*SUMX(VALUES(Operation),Operation[Daily Budget measure]), a))))
Kolumam
Hi Kolumam ,
Can you provide some sample data? It will be very helpful to me.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
