Supporto di Power BI

Cerca

Re: Help with PowerQuery syntax using "if" and "and"

Hi @danasdesk,   You can add a custom column with following formula: #"Added Custom" = Table.AddColumn(#"Previous Step", "Custom", each if [Part Size]>=7 and [Part Size]<=1...

Re: Circular dependency cached error?

Hi @neil_holloway,   Please clear data cache then reopen the report in Power BI desktop:      Best Regards, Qiuyun Yu 

Re: XIRR DAX - Bug

Thanks for your response  Qiuyun Yu.   I'm pretty aware about the XIRR function in PBI and have created a dashboard out of XIRR.    My Question was on the output of the X...

Re: Manual refresh on CosmosDB is successful but is missing data

@okmzrazor,   If this issue is very urgent, I would suggest you to create a support ticket here.   Community Support Team _ Jimmy Tao If this post helps, then please consider Acce...

Re: Gateway cluster with data from two sources on different domains

Hi @JonasKjersgaard,   I haven't found any accurate limitation mentioned in document, but I think current gateway cluster only works on same domain.(in same domain with primary gateway)...

Re: Help writing DAX measure

Hi Tampton,   First you need to have a date column with DD/MM/YYYY, and use DATESMTD function to get desired results.   Regards, Pavan Vanguri.

Re: Opened and Closed ticket count by Shift along with Carry-Over count

Thanks for quick response. My data and requirement is like below. I achieved the first two columns but no clue for the 2nd and 3rd. If you look at the 2nd column. In the 2nd column for Shift 2 we hav...

Re: Help writing DAX measure

@thampton,   You may try DAX function TOTALMTD, create a measure and use DAX formula below: Result = TOTALMTD ( SUM ( Table[Value] ), Table[Date] ) Community Support Team _ Jimmy Tao ...

Re: Sync slicer with report filter

Hi @ahpitre, Based on my research, I am afraid you could not achieve this feature currently, I suggest you submit an idea in ideas forum: https://ideas.powerbi.com/forums/265200-power-bi-ide...

My power BI subscription is free but the notification always show Trial expired

My powerBI subscription is free but the notification always show Trial expired when i try to embed power BI to display on microsoft dynamics NAV role center  , But last time i can embed no probl...

Re: Email Schedule Date Format issue in interface

Lin,   Thanks.   The problem is not between the Desktop and the Service interface but it appears to be a bug in the Service Interface itself.   Perhaps I need to post this somewh...

Re: Displaying Aged Debt over two financial years - Function 'IF' scalar expressions have to be Aggr

@PaulNearney,   This issue may caused by "selectedDate" connected to the date table, how about use summarize or addcolumns instead?   Community Support Team _ Jimmy Tao If this po...

Start currve with value

  I just want my curve to start at MaI but as it's the lowest value it's still at the end of the curve how can you make sure that started with May ? anyone can help ?

Re: Get the list of User form the previous month not included in the range.

I finally could have the measure I wanted with : Churn = VAR previousMinMonth = PREVIOUSMONTH ( 'Date'[Date] ) VAR listOfAssociationIdInRange = DISTINCT( Paiements[id_association]) VAR ...

Re: High density sampling (error?)

hi Yuliana @v-yulgu-msft   Ideally, my desired output is for all 166 series to be visible. If that option is not available, I'd be content with what High Density Sampling is purported to ...

Can I color the image inserted based on the result?

Hi all,   I am trying to measuring performance of each market (e.g. US, Canada , Europe etc) and want to displayed the result with map. Can I insert my map and image and colour it based on th...

Re: Expanded matrix values to still show total on headers?

@Clara   Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.   Regards, ...

Re: Am I able to change the text of table in a live connection using just a measure?

@AJ123,   Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.   Regards, ...

Re: computed column filter

@loijoc08,   Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.   Regard...

Re: excel dataflow filepath setup issue

Hi there Would it be possible to store it in OneDrive for Business, then you can access the file via that Copy Path option?

Re: how to count values of a measure

Use COUNTX or COUNTROWS. Build a table using FILTER and perhaps ADDCOLUMNS that represents your table. Then use COUNTX against that table, perhaps with an additional filter for > 14. For example: ...

Re: Power BI Tricky new question

Try to follow the below steps  Demote to header as row Transpose After Transpose Promote first row as header

Re: Calculate monthly consumption from daily meter reads

I have a setup of data for which I need to calculate the following: - Yearly Usage of a product  - Average Monthly usage of a product - Months of stock on hand - Minimum Lead time - Average...

How can I create a simple index column with dax.

I want to create a simple index column starting with 1 next to the total column.  I can't do it with query editor because it is a calculated table.   Giora

Re: Data Alerts

Hi @eliele, Could you please mark my reply as Answered to close this topic?