Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!