Calculation for cumulative year

Srinivas3350 · ‎07-17-2023

Hello can anyone help me to create this visual I need help in dax to create this andI am not sure which visual to use

i am having margin in table and date table were there is a relation between both table is invoiced date to full date. can anyone help me

so the margin for remaining years is same coming to 2023 the green line it should calculate from jan to july if dates got changed to august the jan to aug

Thanks

Srinivas

Anonymous · ‎07-18-2023

Hi @Srinivas3350 ,

It sounds like a common date range defined by multiple date field analysis requirements. You can take a look at the following blog start, end date part if it helps:

Before You Post, Read This: start, end date

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng