Relative Content

Tag Archive for powerbipowerquerypowerbi-desktop

Select single value fom slicer based on other slicer

Hi I am trying to Sync values from slicer based on other slice which have relation StartDT to StartDt_1 and EndDt to EndDt_1 (both have onetoone and Cross-filter “both”)
Here i StartDt_1 and EndDt_1 has bined to SQL query parameter’s
The reason i am doing to sync is StartDt_1 and EndDt_1 which are bined is i can not convert them as date’s as i am passing them as string in power query
Now , if select any date form StartDt it should reflect on Start_1 and same fpr EndDt’s

Error in output if column cell is empty or null in Power BI

While extracting a pattern from a text column in Power BI, I am getting an error if the column ‘Column1’ has an empty or null value. I have below code which works for non empty values but gives error if ‘column1’ cell is empty or null. I would like to skip the empty and null column values. How to fix this?

Extract a word with specific pattern in Power BI

I have a column named ‘Tags’ in Power BI which contains some text and want to retrieve the word matching the pattern ‘RXXXXXX’ into a new column called ‘Release’.The character after ‘R’ should be a digit. The word can vary in length.I have tried the below thing but it does not work as expected.

Load current data from the Oracle database into Power BI and save/archive it there daily

Every day I load the current data from an Oracle database into PowerBI via SQL query. This table is then called tabLoad, which always contains the same columns, although there is also the valuationtime column in the form DD.MM.YYYY, which indicates today’s/current key date.
This source query happens daily and only contains the current data from today. So I can currently only present the report as a daily report.

Power BI: Load current data from the Oracle database into Power BI and save/archive it there daily

Every day I load the current data from an Oracle database into PowerBI via SQL query. This table is then called tabLoad, which always contains the same columns, although there is also the valuationtime column in the form DD.MM.YYYY, which indicates today’s/current key date.
This source query happens daily and only contains the current data from today. So I can currently only present the report as a daily report.