Forum Discussion
rqh
2 years agoFrequent Visitor
Line Chart with Current Year and Prior Year values
Hi everyone! My line chart has two lines: one for current year sales (CY) and the other for prior year sales (PY). For the most recent year, CY records stop in May. I would like for the chart to n...
- 2 years ago
Hi,
Try this measure
PY net sales new = if([Net sales]=blank(),blank(),[net sales])
If this does not work, then share the download link of the PBI file.
Ashish_Mathur
2 years agoSuper User
Hi,
Try this measure
PY net sales new = if([Net sales]=blank(),blank(),[net sales])
If this does not work, then share the download link of the PBI file.