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,
Actually I have been struglling with my case like this.
I have the data like this. I have join booking date to master date with cardinality many to one
The rule is if there are data on reschedule date, count how many transaction on that period, else count booking date.
And the expectation output should be like this
Anyone could help me to write dax like this case ?
Need help
Thanks
Solved! Go to Solution.
Hi, @chrisyan_manalu ;
First you could create a new table.
newtbale = ADDCOLUMNS( UNION(VALUES('Table'[BOOKING DATE]),VALUES('Table'[RESCHEDULE DATE])),"month",MONTH([BOOKING DATE]))
Then create a measure.
Measure =
CALCULATE(COUNT('Table'[NAME]),FILTER('Table',[RESCHEDULE DATE]<>BLANK()&&MONTH([RESCHEDULE DATE])=MAX('newtbale'[month])))+
CALCULATE(COUNT('Table'[NAME]),FILTER('Table',[RESCHEDULE DATE]=BLANK()&&MONTH([BOOKING DATE])=MAX('newtbale'[month])))
the final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @chrisyan_manalu ;
First you could create a new table.
newtbale = ADDCOLUMNS( UNION(VALUES('Table'[BOOKING DATE]),VALUES('Table'[RESCHEDULE DATE])),"month",MONTH([BOOKING DATE]))
Then create a measure.
Measure =
CALCULATE(COUNT('Table'[NAME]),FILTER('Table',[RESCHEDULE DATE]<>BLANK()&&MONTH([RESCHEDULE DATE])=MAX('newtbale'[month])))+
CALCULATE(COUNT('Table'[NAME]),FILTER('Table',[RESCHEDULE DATE]=BLANK()&&MONTH([BOOKING DATE])=MAX('newtbale'[month])))
the final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@chrisyan_manalu , Not very clear.
Check if this can help
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |