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.
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |