PREVIOUS MONTH returns blank
Hello experts, I want to retrieve the nb_conv_int for the last month so I used PREVIOUS MONTH as you can see below: Nb_conv M-1:=CALCULATE([Nb_conv_inter];PREVIOUSMONTH(Date_table[Date])) But, it returns blank value: I don't know what's going wrong. Here is my data (if you want to help) Below my data model: Thanks in advance.
Measure calculation using different columns based on a value
This is going to be confusing, I apologize in advance. I will try to be as clear as possible. I am trying to create a measure I can use in a visual table that can be filtered by the user. I want that visual to look something like this where $Value is the measure I am trying to create: OrderNbr ShipComplete $Value 12345 Yes $12,000 67891 No $2,000 My question is, is it possible to have the measure sum different column values based on if the order is ShipComplete=Yes or No? In my raw data, each order will have several lines all with differnent $LineValues. In my visual, I want the measure to Sumx(ALL( $LineValues)) IF the order is ShipComplete=Yes regardless of any filters the user applies. If the order is ShipComplete=No I want the measure to only sum the $LineValues of lines that the user filters for. The filters will usually only apply to certain line items on an order so if a filter is applied, the order could get split up in my visual. For example, if the filters result in only 2 of the 5 line items on an order and the order is ShipComplete=Yes then I want the visual to show the sum of all 5 line item values but if the order is ShipComplete=No then I want the visual to show the sum of only the 2 line item values. UPDATE: This is even more complex than I originally thought. My data has 3 levels to it: Order, TopLevel, Item. Each Item has a price associated with it and also have the values which the user will be filtering based on in my data. I want the resulting visual to show a sum on the Order level (as seen in above table). If the order is ship complete I want to see the sum of all Item values in that order regardless of filters. If the order is not ship complete but the item has a TopLevel, I want to see the sum of all Item values in that TopLevel. Otherwise I only want to see the sum of Item values that the user has filtered for. Below is a better example of my raw data set where Color is what the user will filter the visual on. Order# TopLevel# Item# Ship Complete Item$ Color 1 100 101 No 5 red 1 100 102 No 7 green 1 100 103 No 5 green 2 104 Yes 10 red 2 105 Yes 4 green 3 200 106 No 5 red 3 200 107 No 3 green 3 201 108 No 5 red 3 201 109 No 3 green 3 110 No 10 green From this data I want a visual that results in exactly the following (assuming the user filters for "red") Order# Ship Complete Total Value 1 No 17 2 Yes 14 3 No 16 Is this even possible??
calculation based on the previous value
Hi all, I am stuck with creating a dax function, i really need help.. Here is an example, the final in the table should be my result, I have a value for 2019 which is the starting point of the calculation, then its about adding up the previous value calculated multiplied by the factor. Thanks in advance for your support.
Comparing Two Month Column Values, then Arrow Conditional Formatting Based On Comparison
I have three months value in the table Feb,March,April based on the Attribute Wise . please find the screen shot below. i am trying to use conditional formatting for the below table. When MARCH MONTH values are less than FEB MONTH , it will show in conditional formatting Down Arrow. When MARCH MONTH values are Greater than FEB MONTH , it will show in conditional formatting UP Arrow. When APRIL MONTH values are less than MARCH MONTH , it will show in conditional formatting Down Arrow When APRIL MONTH values are Greater than MARCH MONTH , it will show in conditional formatting UP Arrow Can anyone please advise me on this? I am looking for support .
