Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Buget vs Actual on one single table

I have the following transactions table:   CCost Account Date Budget Actual Description 1 1 20190101 100 10 Gas 1 1 20190102 100 50 Salary 1 1 20190201 200 50 Gas ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
7 years ago

avknishokpbi,

 

It worked, but sorry, I thought it was not relevant, but I am using a date table to filter the sales table.

 

CalendarTable                                       Sales

Date      <----------------------------->  Date

Month                                                    CCenter

Day                                                         Account

Year                                                        Budget

                                                               Actual

                                                               Description

 

So using the measure that you said does not works when I use slicers with CalendarTable's columns.

avknishokpbi's avatar
avknishokpbi
Frequent Visitor
7 years ago

Anonymous

 

Try this DAX

 

TotalbudgetbyMonth =
var maxvalue = SUMX(SUMMARIZE(DateTable,DateTable[Month],"amt",MIN(Table1[Budget])),[amt])
return
maxvalue

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    avknishokpbi, almost working.

     

     

    When I use a drill down, it shows the smallest value intead of the sum.