Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Running 12 month Total with Condition

Hi,   I want to create a measure to calculate "Total shipment count for running 12 months". But the condition is if there are multiple shipment(i.e. >1) in same Month&Year(eg. for December 2017 the...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi Anonymous

    As tested, when i add a measure in the SUMX function, it shows the same value as yours.

    Measure 3 = SUMX(DISTINCT(Table2),[Measure])

     

    Here is my pbix

     

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous

Assume table is like

Try this measure

Measure 2 = SUMX(DISTINCT(Table2),[total])

R12 count of shipment 2 = SUMX(
DATESINPERIOD(Table2[date],LASTDATE(Table2[date]),-12,MONTH),[Measure 2])

 

Best Regards

Maggie

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Maggie,

     

    Thanks for your reply.

    Actually I tried creating the measures as you told but its still giving same output in Measure 2. I am not getting if I am going wrong somewhere :-(

     

    Please find the screenshot below,

    • v-juanli-msft's avatar
      v-juanli-msft
      Icon for Community Support rankCommunity Support
      8 years ago

      Hi Anonymous

      As tested, when i add a measure in the SUMX function, it shows the same value as yours.

      Measure 3 = SUMX(DISTINCT(Table2),[Measure])

       

      Here is my pbix