Forum Discussion

pvtrinh89's avatar
pvtrinh89
Frequent Visitor
10 years ago

Create a measure with date

Hi Experts,

I am creating a report that has a date slicer and a measure calcualting as following:

mesuare_name = Total sales/ ( total day in month of date chosen on date slicer) * MTD of the date chosen on the date slicer!.

i would like to see the trend of this measure day by day but i dont know how to do it, so could anyone help me?

Thank in advanced.

 

Best regards,
J.

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    10 years ago

    Do you have a date table? Can you post some sample, sanitized data so that we can see what you are dealing with?

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    10 years ago

    pvtrinh89

     

    According to your description, are you trying to evaluate the value of total sales for month to date, in the current context? If that is the case, using TOTALMTD function may be a possible solution in your scenario. The following formula is for your reference.

    mesuare_name = TOTALMTD ( [Total Sales], 'Date'[Date] )

    We can see the trend of this measure day by day in the report.

     

    If this is not the case, could you post some sample data in your scenario? So that we can better understand your requirement.:smileyhappy:

     

    Regards