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 ,

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.