Create a measure with date

[pvtrinh89]

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.

[v-ljerr-msft]

@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.

Regards

[Greg_Deckler]

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