The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I am new to PowerBI DAX and I working on chart for comparing YTD and prevoius year YTD, however, I am not able to create previous YTD measure as it shows just one single value in Card but I am not able to make it work with chart.
Here are my measures for YTD and previous Year YTD.
YTD = TOTALYTD([Total Sales], 'Date'[Date])
Hi @Radhe try
Previous YTD=
Did I answer your question? Kudos appreciated / accept solution!
Proud to be a Super User!
Hi @some_bih ,
The formula you gave did not work. The previous YTD over years is empty in table over the years but I can see one value in the card visual. I want the previous YTD to compare with YTD over the years. I have attached the Visual and settings. Hope this helps to understand my problem in more detail.
Let me know if you need more information.
The total sales itself is a measure.
Hi @Radhe as you already crrated YTD measure try
Previous YTD =
CALCULATE(
[YTD],
SAMEPERIODLASTYEAR('Date'[Date])
)
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
34 | |
20 | |
19 | |
15 |
User | Count |
---|---|
44 | |
39 | |
33 | |
23 | |
23 |