Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Auto Select Date & Fill 0 If Row is Empty

I use MTD Acc GP Trend = [MTD Acc GP]*DAY(SELECTED VALUE(Calendar[DateKey])) I want if anyone select Month then lastest day auto multiplies in SelectedValue And also Work With Date Filter.
 
& if Result Comes Empty, then Show 0.
 
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    You can create measure like the formula below :

     

    MTD Acc GP Trend = CALCULATE([MTD Acc GP]*DAY(SELECTEDVALUE(Calendar[DateKey]))+0, ALLSELECTED(Data table))

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

3 Replies

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous ,

     

    You can create measure like the formula below :

     

    MTD Acc GP Trend = CALCULATE([MTD Acc GP]*DAY(SELECTEDVALUE(Calendar[DateKey]))+0, ALLSELECTED(Data table))

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous  ,

     

    Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

     

    Best regards

    Amy

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-xicai  Sorry, I forget. No, it doesn't work.