Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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! |
User | Count |
---|---|
54 | |
48 | |
19 | |
16 | |
15 |
User | Count |
---|---|
115 | |
42 | |
41 | |
27 | |
22 |