Forum Discussion
Dax query
can any one suggest me the correct dax code for 12 month rolling average ( i try to do it but its showing incorrect result) My code :- 12 Month Rolling Average = CALCULATE(AVERAGEX('DMADP OPEM_A...
Hi yulina, thanks for your response... FYI [Total TR] is not coming from date dimention table. Its a another dax measure (Total TR= count(fact table TRID)). Also note TRid is in the form of text ( which has values like alpha numerical (Ex ASDJ-2765)