Power BI PARALLELPERIOD

Power BI
1

take the data directly using SQL queries.
I’m using Power BI I’m using a parallel period formula to display salesperson data. I use this formula because I want to compare not one year.

Müügitulu Aasta 1 = CALCULATE(excel_myygiarve_read_3_finants[Müügitulu],PARALLELPERIOD(excel_myygiarve_read_3_finants[Kuupäev],1,YEAR))

I have salesmen who came to work in 2024. If I use this formula, this data does not appear.

But if I use the formula, these data will come.

Müügitulu 2024 = CALCULATE(excel_myygiarve_read_3_finants[Müügitulu],FILTER(excel_myygiarve_read_3_finants,YEAR(excel_myygiarve_read_3_finants[Kuupäev])=2024))

what am i doing wrong in this formula?

Müügitulu Aasta 1 = CALCULATE(excel_myygiarve_read_3_finants[Müügitulu],PARALLELPERIOD(excel_myygiarve_read_3_finants[Kuupäev],1,YEAR))

image
image1357×434 62.5 KB

2

Can you share your PBIX?

3

M_Müük (Tiit) – test.pbix (6.7 MB)
This view requires a Username and Password. Because it is done on top of a SQL query

4

I couldn’t open the file you sent. Can you simplify it?

5

The file asks for a username, it is: Tiit Perve
password: Puiduyrask44

6

I still haven’t got it