The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I am using some measures based on the PARALLELLPERIOD function to compare the figures for current month with last month. (Data is members statistics monthly collected).
I would like to use the "Slicer" control in a report and let the users select a year and then get a list of all month that year and the monthly changes. This works fine for all months except january. I guess this is due to that the data for december (previous year) is not in the selection.
Strange thing is that it works fine if the user selects specific dates in the slider (eg. 2016-01-01 --- 2016-12-31)
Does anybody have a workaround or solution for this behaviour?
Best Regards
Solved! Go to Solution.
Hi @boxen_solution,
I can’t reproduce your scenario. Please post more details. A snapshot will be great.
In this situation, it works fine.
Current = SUMX ( Sales, Sales[Quantity] * Sales[Unit Price] )
LastMonth = CALCULATE ( SUMX ( Sales, Sales[Quantity] * Sales[Unit Price] ), PARALLELPERIOD ( 'Date'[Date], -1, MONTH ) )
Best Regards!
Dale
Hi @boxen_solution,
I can’t reproduce your scenario. Please post more details. A snapshot will be great.
In this situation, it works fine.
Current = SUMX ( Sales, Sales[Quantity] * Sales[Unit Price] )
LastMonth = CALCULATE ( SUMX ( Sales, Sales[Quantity] * Sales[Unit Price] ), PARALLELPERIOD ( 'Date'[Date], -1, MONTH ) )
Best Regards!
Dale
Hi and thanks for your reply. I'll try to explain with two screenshots.
Here i use the slicer with the period selection based on a from and to date. Now it works.
If you look at the first row and the third column (Förändring antal aktiva medlemmar(), it displays -43274. This is showing the change in active members since the december figures for 2015.
If i use the same column as refiner, but a different visual appearance of the selector (showing full years). It does not work.
Now the expected change in January is not displaying the change from december, but the total number of active members.
See that column three is sam as column 2 for january. The other months are displaying correctly.
Hi again Dale.
Together with you suggestions in the other thread where you helped me, i got this working. I think the key was to add an extra date-table with all running dates.
I am so glad your problem is solved. Thank you for sharing it with us. I used a "DATE" table indeed. I think it's a good practice to use a "DATE" table when using time intelligence functions.
Best Regards!
Dale
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 August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
80 | |
78 | |
44 | |
37 |
User | Count |
---|---|
157 | |
112 | |
64 | |
60 | |
54 |