line chart Dax

[CapSiriMBRD]

Hello team

In line chart I am required to compare the count from current year to previous year
for current year & month I need to get the data from all years from 2019  to 2023 all the months and current year month data I need to show how can I do that

CALCULATE([1_Y],FILTER(Query1,

Query1[Year] >= 2019 && Query1[Year] <= YEAR(TODAY())) && MONTH(TODAY()) >= Query1[MonthID])

)

can anyone help me solving this 

[Anonymous]

Hi @CapSiriMBRD ,

If I understand correctly, the issue is that you want to compare the count from current year to pervious year. In order to make a deep troubleshooting, could you please provide more raw data(exclude sensitive data) with Text format? It would be helpful to find out the solution.

You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

Looking forward to your reply.

Best Regards