Forum Discussion

Helper I

4 years ago

Solved

YTD Calculation

Hi all,

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

Thank you very much.

Best regards,

Sya

Jihwan_Kim
4 years ago
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.

3 Replies

Jihwan_Kim
Super User
4 years ago
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.
- sya
  Helper I
  4 years ago
  Hi Jihwan_Kim ,
  
  PBI:
  https://1drv.ms/u/s!AjXpGcOFDGB2iFiLzHJzUnx8F9yk?e=8c4M9f
  
  excel:
  https://1drv.ms/x/s!AjXpGcOFDGB2iFnCFPPFJUA7dAlh?e=s4Epw9
  
  Let me know if there's issue to access the files.
  Thanks a lot!
  
  Sya
  - Jihwan_Kim
    Super User
    4 years ago
    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.