Find the Latest Order date in the selected date range for Tag ID
Hi, I want to display the last order date for tag id with in selected date range. Figure 1: Month MAY Month : April with respective of the selected month, should show only one record in a month for a Tag ID's Please advice , measure or calculated column.
How to add or substract measures created in DAX and obtained from Source SQL?
Hi Experts, I have some averages and Count I have from source file via the T-SQL and I have to create a few measures in the DAX Example in my case TotalCntSales (I have this from SQL and in Dax showing up as Summation symbol) Now I created Dax with Total sales of Sales_East, SalesWest As a validity check I wanted to create measure with Total Other Sales = TotalCntSales - (Measure_Sales_East + Measure_Sales_West) But I can only see the Measures Created in Dax not what I have derived from Source. Workaround. I have created another measure in Dax for Total Sales but want to know if there is a smarter ways of doing it? Thanks a lot.
How to preserve excel formatting while exporting to excel in Power BI Report Builder
Hi Community, I need below requirement. How to preserve default excel formatting boarders for other cells which are not part of report output ,while exporting to excel in Power BI Report Builder. What i am getting now: My Expectation: Other cells in excel export default boarders shoud populate.
FORMAT function with standard string and 1 decimal digit
I have a pivot table and for the calculation of the values i am using a switch statement. For each different row i have a different calculation. Code of each row is like this: SWITCH(SELECTEDVALUE(v_raw_data[metric_code]), "T_01",FORMAT([T_01],SELECTEDVALUE(v_raw_data[value_formatter])), BLANK()) In the value_formatter i am using the standard string list. PREDEFINED NUMERIC FORMATS Format Description "General Number" Displays number with no thousand separators. "Currency" Displays number with thousand separators, if appropriate; displays two digits to the right of the decimal separator. Output is based on system locale settings. "Fixed" Displays at least one digit to the left and two digits to the right of the decimal separator. "Standard" Displays number with thousand separators, at least one digit to the left and two digits to the right of the decimal separator. "Percent" Displays number multiplied by 100 with a percent sign (%) appended immediately to the right; always displays two digits to the right of the decimal separator. "Scientific" Uses standard scientific notation, providing two significant digits. "Yes/No" Displays No if number is 0; otherwise, displays Yes. "True/False" Displays False if number is 0; otherwise, displays True. "On/Off" Displays Off if number is 0; otherwise, displays On. In the way that this works if decimals exist then i always get 2 decimals. Else i have integers. I am giving you also i picture How can i change it to give me if we have decimals only one. But not all values to have one decimal. In another way if i have these two function: 1) FORMAT ( 5, "0.#" ) 2) FORMAT ( 0.56, "0.#" ) How can i succeed with a result of 1) 5 2) 0.6 with the same String format.Parent life matches to child life or not?
Hi Team, Could you please help me out with below scenario, I need a calculate colum to get the result column, Here We are considering Sno=0 is a Parent. Example, Asset 1001 with Sno=0 is a Parent asset, and their child are Asset 1001, sno=1 and 2(Need to consider Code as well).. Parent life is 12 years 0months In above image we can see, Asset 1001 and sno 1 is child and their life is not equal to Parent Life so it is "Anamoly" second Child , Asset 1001 and sno 2 is 2nd child and their life is equal to Parent so it is "Not Anamoly". We need to consider code and Asset. Regards, Siva554
