Month to Month and Week to week diff in a line graph

[MuthalibAbdul]

Expected solution Youtuve Tutotial

Expected 

My results

I am trying to build a graph that shows month by month diff and percentages. The only difference between the video and my scenario is my total cannot be a sum because I am counting patients names. Hence countrows functions to count how many patients were seen. However my results should ideally be total encounters and the previous month diff on the right. My total encounter and Previous month are exactly same though. Its like I am using similar function when infact I am using two diff measures

[v-sdhruv]

Hi @MuthalibAbdul ,

Since we didnt hear back, we would be closing this thread.
If you need any assistance, feel free to reach out by creating a new post.

Thank you for using Microsoft Community Forum

[v-sdhruv]

Hi @MuthalibAbdul ,

Just wanted to check if you got a chance to review the suggestions provided and whether that helped you resolve your query?

Thank You

[v-sdhruv]

Hi @MuthalibAbdul ,

Just wanted to check if you got a chance to review the suggestions provided and whether that helped you resolve your query?

Thank You

[v-sdhruv]

Hi @MuthalibAbdul ,

You can try-

PM Encounters = 
CALCULATE(
    [Total encounters],
    DATESINPERIOD(
        'Calendar'[Date],
        EOMONTH(MAX('Calendar'[Date]), -1),
        1,
        MONTH
    )
)

Hope this helps!

[danextian]

Hi @MuthalibAbdul 

It seems like you are  using a dedicated dates table but you haven't turned off auto-datetime (.[Date] after the date colunmn). Try disabling it and also set your dates table as such. Set and use date tables in Power BI Desktop 

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.