Solved: Re: YTD Calculation

sya · ‎02-28-2022

Hi all,

Any idea why the YTD Revenue is blank for January and February?

Thank you very much.

Best regards,

Sya

Jihwan_Kim · ‎03-01-2022

Hi,

I think the reason is because your Calendar table has two Januarys and two Februarys.

I suggest putting a year column into the visualization might solve the issue.

Or, you can also create Year-Month column in order not to make any confusion.

Thank you.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

View solution in original post

Jihwan_Kim · ‎02-28-2022

Hi,

can you share your sample pbix file's link here?

And then I can try to have a look into it to find out the cause.

Thank you.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

sya · ‎02-28-2022

Hi @Jihwan_Kim ,

PBI:

excel:

Let me know if there's issue to access the files.

Thanks a lot!

Sya

Jihwan_Kim · ‎03-01-2022

Hi,

I think the reason is because your Calendar table has two Januarys and two Februarys.

I suggest putting a year column into the visualization might solve the issue.

Or, you can also create Year-Month column in order not to make any confusion.

Thank you.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

YTD Calculation