Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello! Can't seem to get the correct value for sales of previous period when multiple sliders are involved. Already tried multiple solutions but I can't figure out what's missing. All the data are placed in a single table already to simplify the visualization.
DeptSalesByType Table columns:
Sales (Fixed Decimal Number)
Department (Text)
Transaction_date (Whole Number)
Type (Text)
FullDate (converted Date/Time from Transaction_Date)
4 Sliders:
Year (2017 | 2018 | 2019 | 2020)
Month (Jan | Feb | Mar | .... Nov | Dec)
Type ( All | Loyalty | Non-Loyalty)
Department (Cosmetics | Kids | Mens | Womens)
Measures:
Solved! Go to Solution.
Actually managed to solve this. Had to create a duplicate table of the FullDate and it worked. Not sure if it's the right way though as I made the date redudant.
Actually managed to solve this. Had to create a duplicate table of the FullDate and it worked. Not sure if it's the right way though as I made the date redudant.
You only a Full Date column, I don't see how did you get the Start and End period, can you just share sample pbix.
Paul Zheng _ Community Support Team
Hi,
Here they are:
Start Current Period = FIRSTDATE(DeptSalesByType[FullDate])
End Current Period = LASTDATE(DeptSalesByType[FullDate])
Start Previous Period = [End Previous Period]-[Days Current Period]
End Previous Period = [Start Current Period]-1
Days Current Period = DATEDIFF([Start Current Period],[End Current Period],day)
This is a question about DAX, not Power Query... Can you please post this on the right forum?
A very quick hint why this does not work can be found at
Understand star schema and the importance for Power BI - Power BI | Microsoft Docs
and
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
46 | |
31 | |
30 | |
18 | |
18 |