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.
I want to add a "1" in the beginning of each day and only once.
rmd_date | I want to create this column |
12-04-2023 | 0 |
12-04-2023 | 1 |
11-04-2023 | 0 |
11-04-2023 | 0 |
11-04-2023 | 1 |
10-04-2023 | 1 |
9-04-2023 | 0 |
9-04-2023 | 0 |
9-04-2023 | 1 |
Okay to do this:
First i would sort the order of you date field ascending then add an index in power query.
then create a column in DAX:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Thank you for your resposse. It however doesn't seem to work...
My line:
Hmmm okay, try changing the COUNTROWS to COUNT
This also doesn't seem to work... Could you send me the PBI-file? 🙂
I don't seem to be able to share the file, i'm getting an unsupported message. Do you have a share drive i can drop it in?
Hi, you could use a calculated column with DAX,
i've assumed the 1 and 0 depends on whether you want a day adding or not if so:
Thank you. I have updated the question. Hope it makes more sense now 🙂
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |