The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi all,
please help me with this following questions:
I am new to powe bi and trying this...
I have column with status and updated date and i need to achieve this in DAX, kindly provide your input.
Ex:
status = Closed AND (status changed to Closed after '2023/04/01' AND status changed to Closed before '2023/04/30')
Solved! Go to Solution.
Hi @Sams1 ,
Please have a try.
Create a measure.
Closed in April 2023 =
CALCULATE (
COUNTROWS ( Table1 ),
FILTER (
Table1,
Table1[Status] = "Closed"
&& Table1[UpdatedDate] >= DATE ( 2023, 4, 1 )
&& Table1[UpdatedDate] <= DATE ( 2023, 4, 30 )
)
)
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Sams1 ,
Please have a try.
Create a measure.
Closed in April 2023 =
CALCULATE (
COUNTROWS ( Table1 ),
FILTER (
Table1,
Table1[Status] = "Closed"
&& Table1[UpdatedDate] >= DATE ( 2023, 4, 1 )
&& Table1[UpdatedDate] <= DATE ( 2023, 4, 30 )
)
)
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |