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.
Hi All,
Does anyone know how to find current period and previous period total sales by making your data table autoupdate?
For example, the first pay period starts from 1st to 15th of each month and second pay period is from 16th to EOMONTH. This means that the "CURRENT MONTH" can fall into one of two pay periods.
I need my date table to identify whether the pay period is in P1 or P2, and accordingly assing "CURRENT MONTH" label. The month prior to "current month' will have label "PREVIOUS MONTH".
Cannot figure out how to do this. Is anyone able to help?
Thanks all
Solved! Go to Solution.
Hi @Anonymous
My understanding is that you need something like below.
pay period = IF( DAY( 'Table'[Date] ) <= 15, "P1", "P2" )
If not please please can you create a sample with the outcome that you are expecting.
Hi @Anonymous ,
If above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!
Hi @Anonymous
My understanding is that you need something like below.
pay period = IF( DAY( 'Table'[Date] ) <= 15, "P1", "P2" )
If not please please can you create a sample with the outcome that you are expecting.
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 |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |