topic Re: Calculation for cumulative year in DAX Commands and Tips

Calculation for cumulative year

Srinivas3350 — Mon, 17 Jul 2023 14:56:35 GMT

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

Re: Calculation for cumulative year

Anonymous — Wed, 19 Jul 2023 05:03:24 GMT

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