Forum Discussion
How to count 2 condition?
Hi, Anonymous
I am not sure how your data type in your pbix file looks like, but I think you need to have a date-type column in the table.
Please check the below pbix file's link.
https://www.dropbox.com/s/xbgle5ipajq5i83/adamasmay.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
Hi, Anonymous
Please try the below.
Count of Implement Status Date =
VAR __CurrentMeasure =
CALCULATE (
COUNTA ( 'Update'[Status Date] ),
EOMONTH ( 'Update'[Status Date], -1 ) + 1
= DATE ( 2021, 4, 1 ),
'Update'[Status] = "Complete"
)
RETURN
IF ( ISBLANK ( __CurrentMeasure ), 0, __CurrentMeasure )
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
Jihwan_KimIt show error can't load data from image.
It errorshow DAX not support compare date and text. Please try function Value or format for convert.
Please guide me.
Hi, Anonymous
Thank you for your feedback.
Please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate measure.
Thanks.
Jihwan_KimI can't send .pbix file to you.
If I share file excel that I use read in power bi.
Are you okay?
Hi, Anonymous
Yes, please share your excel file with mentioning how you want to show in visual, for instance, table visual or bar chart, or any others.