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.
In this example, all of the transactions on this sheet belong to the accounting month for March. But one of the expenses which is April 1 was included in this report for whatever reason. However, it is part of that reporting period and there is no way to remove it. In this instance, I don’t want the name of the month to roll over to April and want the entire column to remain March. But I have 20 sheets that will have the same issue. And I don’t think replace values is going to be practical for each sheet one by one. How do I force the whole column to stay the same reporting month regardless of the invoice date?
Is this going to be complicated?
Solved! Go to Solution.
There might be an easier way to do this, but below is an option for you as long as you are trying to capture the month name of the earliest date in your table.
And your end result will look something like this:
There might be an easier way to do this, but below is an option for you as long as you are trying to capture the month name of the earliest date in your table.
And your end result will look something like this:
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |