Forum Discussion
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 c...
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