Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
Hi Folks,
i have multiple columns in the table . i want use WeekNumber , Dollors. There are multiple values in every week. For sample i am showing few. i want to get this below using weeknumber and Dollors. Can you please help me in this. How to create DAX.
WeekNumber | Dollors |
202201 | 10 |
202202 | 20 |
202203 | 30 |
202204 | 60 |
202205 | 70 |
202206 | 90 |
202207 | 100 |
202208 | 200 |
202209 | 100 |
202210 | 110 |
202211 | 120 |
202212 | 130 |
202301 | 160 |
202302 | 180 |
202303 | 190 |
202304 | 200 |
202305 | 250 |
202306 | 300 |
202307 | 400 |
202308 | 5000 |
202309 | 400 |
202310 | 200 |
202311 | 100 |
Please provide better sample data, covering more than two quarters. Clearly indicate which week belongs to which quarter. Ideally you would have a date column that you could tie to a calendar table.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.