Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello Team Power BI,
I need your help to solve this issue ! I have process by date as shown below :
I need to show matrix as with status by month :
If Month < Date begin then "Not Begin"
If Month between Date begin and Date End then "Begin"
If Month between Date End and Payment date then "Waiting"
Else "Payed"
This is the expected result :
DAX or Power Query ??
any help will be appreciated !
Thanx
check your results, it seems to me that you got everything mixed up, for example for C the result should be like this
and why for F the year is 2022? it should be 2023
User | Count |
---|---|
85 | |
80 | |
77 | |
49 | |
41 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |