Forum Discussion
DAX Nested IF issue
Try this
measure=if(selectevalue(table [delivery date]) <= min(date[date]) && selectevalue(table [invoice issue date]) <= min(date[date]) && selectevalue(table [client payment date]) > min(date[date]), sum(table[amount column]),0)
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.check my blog here
https://community.powerbi.com/t5/Community-Blog/Connecting-to-a-Tabular-Model-Using-Power-BI/ba-p/913784
Try this
measure=if(selectevalue(table [delivery date]) <= min(date[date]) && selectevalue(table [invoice issue date]) <= min(date[date]) && selectevalue(table [client payment date]) > min(date[date]), sum(table[amount column]),0)
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
check my blog here
https://community.powerbi.com/t5/Community-Blog/Connecting-to-a-Tabular-Model-Using-Power-BI/ba-p/913784
Tweaked around and got it to work in the intended way using the matrix. One issue though is that- how could I get the measure to sum at the end of the matrix table, would that requier another measure?
Also while each outstanding amount is order# based, it currently doesn't aggregate the amounts by selected clients, I originally did not include this as I though that PB will aggregate all the orders amounts under clients by default.
So essentially I would like to have the total of outstanding per client and TOTAl at the end of each day BY order based aggregation if that is posslble.
Thank You & Kind Regards
Joel Truuvert