Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Table was bad to read.
Date Value Categros
01.01.2020 1 a
....
DateValueCategory
01.01.2020 | 1 | a |
01.01.2021 | 2 | a |
01.01.2022 | 3 | a |
01.01.2023 | 4 | a |
01.01.2020 | 10 | b |
01.02.2021 | 20 | b |
01.03.2022 | 30 | b |
01.04.2023 | 40 | b |
Hi,
I have a problem with a similar topic. But in my case I have only values for category when I have also a Value. But I still want to have a tabel who have entries for each day 1st of Jan, 2nd of Jan, ... with the las value to get a time series with the SUM by category. For all Dates in the Calendar table that reachts until end of 2023.
01.01.2020 | 1 | a |
01.01.2021 | 2 | a |
01.01.2022 | 3 | a |
01.01.2023 | 4 | a |
01.01.2020 | 10 | b |
01.02.2021 | 20 | b |
01.03.2022 | 30 | b |
01.04.2023 | 40 | b |
Have you any idea?
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
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 |
---|---|
54 | |
26 | |
21 | |
15 | |
11 |
User | Count |
---|---|
77 | |
62 | |
44 | |
18 | |
12 |