Forum Discussion
undefined
Hello everyone! I have a question about a mesuare. Im trying to make a recount according the month.
As you can see, the present month is ok, but when I try to see the following month, the result is wrong( eg in the column that it said "MARZO " in Recount next month it should appear number 16, that correspond to April.
Best Regards!
I could fix it!
Thank you very much in any way
Best Regards!
6 Replies
Make sure you have your Calendar table 'Mark as Date table' see the bottom of this blog for how to:
https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html
Also, then you can update the Recount Next Month measure to:
Recount Next Month = CALCULATE( [Recount Present Month], DATEADD(Calendar[Date], 1, MONTH))
That pattern of CALCULATE( [Measure], DATEADD(Calendar[Date], #, MONTH)) will always work. You can even switch DATEADD for other time intelligence measures and MONTH for other YEAR, etc.
- Dear Allison, thank you for you answer... Unfortunately, this measure dont work :(... I used your calendar but the measure for the next month that it gave is exactly the same as the present month...this is the mesuare for the present month:Recount Present Month = SUMX (FILTER (dot, dot [Overnight date]), dot [Count])The table dot has the following form:Reservation number type of room overnight night Count (count by reservation number and room type)899 single 4/4/2021 1899 junior 4/4/2021 1Best Regards!
Hi,
Share the link from where i can download your PBI file.
<iframe width="600" height="373.5" src="https://app.powerbi.com/view?r=eyJrIjoiYTQ3Y2FmMjYtNjU3OC00MjY4LTg4NjMtMDY0MzE3ZGVkZGJmIiwidCI6ImE0N2MzZWRiLWY4NmMtNDFmNC1iYjU5LTk1N2M4NTdiODE1YyJ9&pageName=ReportSection2e1f6d6e076e0185bdb0" frameborder="0" allowFullScreen="true"></iframe>
Hi,
That is not a file download link. Also, would it be possible to share the file in English language?
